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..
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()
Field in ('A','B','C') ORField not in ('F')
QV Versionmatch (Field,'A','B','C') ORnot match (Field,'F')
Retrieving data ...