...
UPDATE A92_ADDRESS_PROPERTY
SET ADDRESS_PROPERTY_TXT = UPPER(ADDRESS_PROPERTY_TXT) || 'X'
WHERE ADDRESS_PROPERTY_TXT LIKE '%@%' AND ADDRESS_PROPERTY_TXT NOT LIKE '%X' ;
/* ensure CAWIS admin’s email remains unmarked */
UPDATE A92_ADDRESS_PROPERTY
SET ADDRESS_PROPERTY_TXT = 'SYLVIE.BLAIS@TC.GC.CA'
WHERE ADDRESS_PROPERTY_TXT = 'SYLVIE.BLAIS@TC.GC.CAX' ;
5) ENSURE THAT CONTINUING AIRWORTHINESS ACCOUNTS REMAIN ACTIVE
...