View Single Post
  #3 (permalink)  
Old May 27th, 2007, 01:12 PM
jurio jurio is offline
Registered User
 
Join Date: May 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the reply.

My issue with OR IS NULL approach is that if a parameter is supplied, such as "abc", then all rows which contain "abc" will be returned, along with all rows which contain null values.

Since this query is going to be used for user searches, if the user searches for a specific value, they wont want to see null rows in addition to their rows containing the value(s) they supply.