IS THERE A "NOTIN" OPERATOR 1

[edteck]

I want to select information from a table (string) by excluding that which I don't want. Is there a "NOTIN" operator or equivalent?

e.g. I want to select records do not contain the word "crane" and also the records which do not contain the word "wheel"

 

[phirst]

Hi edteck,
use either
NOT ({myfield} in ["crane", "wheel"])
or
{myfield} <> &quot;crane&quot; AND
{myfield} <> &quot;wheel&quot;

Though be careful as queries with NOT and NOT EQUALS rarely use indexes and can be very slow.
Hope this helps,
phirst.