I remember seeing something like this in the past, which worked. Does it really reliably exist?

WHERE &var LIKE IN ('%thing1%','%thing2%')

This message has been edited. Last edited by: mbondr,

I don't see that syntax in the language reference. The only reference to using multiple masks is the an IF statement.

To search for records with the LIKE operator, use 

IF field LIKE 'mask1' [OR 'mask2'...]To reject records based on the mask value, use 

IF field UNLIKE 'mask1' [OR 'mask2' ...]

If it worked in the past you may be a victim of code tightening.

Okay. As jgelona said, this is the syntax:

APPT_LOCATION_DISP NOT LIKE 'APIA%' OR 'CHU%' OR 'EAT%' OR . . .