Search Criteria | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Search Criteria

hi all, I want to make search my taking 6 perameters as input
In that six, some may or may not be null,
How to make the search query by these perameters. Regards
Rajesh.
Please post more information, such as table structure and what you then want to achieve. I suspect you mean something like this:http://www.sommarskog.se/dyn-search.html
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs

Something like Where ([email protected] or @param1 is null) and ([email protected] or @param2 is null) and … Madhivanan Failing to plan is Planning to fail
Thanks Kalis and Madhivanan I got it. regards
rajesh.
]]>