I can't figure out wth I am doing wrong. Please someone smarter than me point at my error and explain? Just trying to get a text column to display 1 of four options depending on character combinations in entityid.

CASE WHEN (UPPER(SUBSTR({entityid}, 1, 4)) = 'IR -' THEN 'Ireland Subsidiary' WHEN (UPPER(SUBSTR({entityid}, 1, 4)) = 'AU -' THEN 'Australian Subsidiary' WHEN (UPPER(SUBSTR({entityid}, 1, 4)) = 'CA -' THEN 'Canadian Subsidiary' ELSE NULL END