Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!!
Hi,
You can use the function NOT EXISTS in your scripts.
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