Hi,

Kindly help me about this scenario.

I have a grid that has inputbox at the bottom of it. The user can input to the inputbox as quick search. I need to improve the quick search. Here is the input of the user:

156 OR NOT BLANK

I want to execute the query like this.

Select * from Product where columnfield LIKE '%156%' OR columnfield IS NOT NULL

I need to know your ideas on how to that in code.

Thanks and in-advance.