Just copied well known link from very recent thread in this forum (just check one about "optional parameters in WHERE...")
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]