Creating An Advanced Search

[gderosa]

I have searched for hours regarding this but I am trying to make an advanced search page for my application that has drop downs for 'Greater Than', 'Equals', 'Less Than'. For example the search page needs to be like this:

ENDDATE: [dropdown with greater than, equals, or less than] [user enters date in this textbox]

How can I manipulate the SQL search string to change the value when the user selects a search criteria in the dropdown?

At the moment it is SELECT * FROM Table WHERE EndDate LIKE TextBox1%

I would like to replace the LIKE in the SQL Select Statement with whatever the user selects from the dropdown. For example if they select Less Than, then the string would need to be:

SELECT * FROM Table WHERE EndDate < TextBox1

I am also going to have several fields like this so I cannot use conditional statements such as IF DropDownList1.Text = "Less Than" THEN sqlStateMent = Bla

Thanks in advance for your help!!!