Select Statement using NOT IN

[#1]

Can anyone explane to me how i can use the NOT IN function in my where clause? I want to exclude multiple values from loading..

thank you!!!!

[#2]

Hi,

You can use the function NOT EXISTS in your scripts.

[hector]

Hi, you can use match() which essentially is the same as an "IN" clause in SQL Server, as well you can use not match()

SQL Version

Field in ('A','B','C') OR
Field not in ('F')

QV Version
match (Field,'A','B','C') OR
not match (Field,'F')

Rgds