IF THEN OUTPUT - LIKE Statement

[Deesee]

How do I use 'LIKE' or something similar to find anything that starts
with OCM ? Do I use a WHERE statement or something else?

IF UPCASE(id_role) like 'OCM%'
THEN OUTPUT work.output_ocm;

[PaigeMiller · Accepted solution]

IF UPCASE(id_role) =: 'OCM' then OUTPUT work.output_ocm;

Note the colon after the equal sign ... equal followed by colon indicates "starts with" ... that you want to find records where UPCASE(ID_ROLE) starts with 'OCM'

[Deesee]

THANKS!