Exclution of few values from a field

[brijesh1991]

Hi guys, I had 100000 ApplicationNo in a SQL table. I am loading them like this: Load ApplicationNo from TableName; which will load all the ApplicationNos. Now I wanted to remove 5000 ApplicationNo(which are in  a Excel file) from whole list. Your suggestions and ideas are too importart. . . {I can't change anything in SQL table like adding a flag or something else since many other users are using the same table. All we have to do is in QVW file at loading time.} Best Regards, Brijesh

[#2 · Accepted solution]

You can use exist function..

attached example from cook book.

Karthik

[brijesh1991]

Hey Karthik.. Thanks.. it's working fine!! Thanks thanks!!! 🙂