Quote Originally Posted by nagasrikanth View Post
tuber,

I think you are on the right way only.. If you want to search on 2 different fields, Your SQL Statement is perfectly right.
Coming to long SQL Statement concern, What is the problem even though it was too much long ?? Your requirement needs that..
Coming to speed also, I dont think, it will create a problem. In my case, I'm checking almost around 1 Lakh of records with around 12 to 15 criterias easily.

Developers, Correct me if i'm wrong..

Happy Coding,
Srikanth
Yes, my only real concern is that this will be a very long query, with 9 search options that all need to be able to search 2 different columns.

Writing that many ORs is going to get really confusing too.