Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm loading records in Data Load Mgr, but would like to exclude a small number (6 records) based upon their unique 'PS #" assignment. After searching this forum, I think I need to use the "where not" command in my script.
Here is the script I created using this command.
This yields an "Unknown Statement' error. I'm sure it is just a syntax, or command placement error,
Can anyone help, please?
Much appreciated!
Try this:
Where not Match("PS #", 1506919, 1100919, 1505558, 1505559, 1505566, 1505567);
Try this:
Where not Match("PS #", 1506919, 1100919, 1505558, 1505559, 1505566, 1505567);
Sunny - you are absolutely THE B E S T !
Thanks again and I hope you have a nice day.
Hahahaha thanks Mike, I am glad I was able to help my friend