SQL Server Performance Forum – Threads Archive
Search Criteria
hi all, I want to make search my taking 6 perameters as inputIn 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.
]]>