How to return all records for Gridview select command parameter.

Question

Using asp.net In the gridview select command, how can I select all records, including null, for a particular field. I have a parameter which changes with the dropdown selection. I have a default list item set to % but this will not pull records with null. I tried this: Where ((@submit LIKE '%' AND user_submit LIKE @submit OR user_submit IS NULL) OR (@submit NOT LIKE '%' AND user_submit LIKE @submit)) but am getting null records in both sides of the or statement. I aslo tried a case statement but cannot figure out how to select both % and 'is null'.

Thanks in advanced

Answer 1

If I'm understaning correctly I think you want to select based on a criteria but also if the field has a value of null.

Something like this should work for you

select whatever from Table_1 where whatever like '%' or whatever is null