Hi, I have some filters that use the qualification != $NULL$. In the documentation it says to avoid using != as it will do a full table scan.
My question is 'does having != $NULL$ AND Field1 = Organization' make the full table scan smaller? Or Is it better to do a != $NULL$ or LIKE 'CU%" When I try the LIKE qualification, it seems a lot slower (timeout message) compared to the != $NULL$ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"