Hi James,
Try to use this where statement:
WHERE not wildmatch(FieldName, ‘value’, ‘value2’, ‘value3’)
value, value2, value3 should be data you want to exclude.
You can either use wildmatch or mixmatch function.
wildmatch –> ‘valu*’ (wildmatch search)
mixmatch –> ‘value’ (exact data value search)
Hope it helps.
