From 989d747c8dd342f8437667ae81f078285167dd0c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 6 Oct 2025 17:15:05 +0000 Subject: [PATCH] Mark PEOPLE with "/" in their name inactive; conversion problem #39 --- conversion/load_data.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/conversion/load_data.sql b/conversion/load_data.sql index 085a0bd..91a5611 100644 --- a/conversion/load_data.sql +++ b/conversion/load_data.sql @@ -549,4 +549,5 @@ SELECT UPDATE people SET active = FALSE WHERE person = 'UNK' - OR person = 'NONE'; + OR person = 'NONE' + OR person LIKE '%/%'; -- problem #39 -- 2.34.1