Hello,
I am doing one application for filtering records according to filter entered by user.
I have one drop down list for filter types and one text box for filter string.
Filter conditions in drop down lists are :
?*, *?*, =, !=, >, >=, <, <=, etc
And i think end user will put following valid values in text box-
2013/04/04
April 2013
2013
07 Apr 2013
07 Apr
12:00
11:30 PM
My database table have following field-
uploaded_on (smalldatetime)
I have to write query such that whatever filter entered by user is, records should be filtered according to that.
Thanks.