I need to do this query. Is there a way to make it simpler so wont get the complez expression message?
SELECT UIC, CCtr,
IIf (CCtr LIKE "230A?00*" OR CCtr LIKE "230A?N09*" OR CCtr LIKE "230A?N03*", "N00/09/03",
IIf (CCtr LIKE "230A?N0AL*", "N00AL",
IIf (CCtr LIKE "230A?N04%", "N04",
IIf (CCtr LIKE "230A?N05*", "N05",
IIf (CCtr LIKE "230A?N1*", "N1",
IIf (CCtr LIKE "230A?NTEN0*", "N10",
IIf (CCtr LIKE "230A?N3*" OR CCtr LIKE "230A?N4*", "N3/4",
IIf (CCtr LIKE "230A?N5*", "N5",
IIf (CCtr LIKE "230A?N6*", "N6",
IIf (CCtr LIKE "230A?N7*", "N7",
IIf (CCtr LIKE "230A?N8*", "N8",
IIf (CCtr LIKE "230A?N91*", "N91",
IIf (CCtr LIKE "230A?N0CC*", "NOCC",
IIf (CCtr LIKE "230A?N0GC*", "NOGC",
IIf (CCtr LIKE "230A?OP*", "NOP")))))))))))))) AS DivCode
FROM [Quarterly Report]
WHERE ( UIC LIKE "*23" OR UIC = "3598A");