I'm trying to pass an operator(>,<,=) and numeric text box value to a SQL stored procedure. I would like to know the proper syntax for the following SQL case statment. I want to use each operator as a case. for example, if the operator is >, then select values from a column where the values are greater tha the textbox variable. if the operator is <, then select values from a column that are less than the textbox value.