Sql Stored Procedure with custom Operators

[fernandomierhicks]

Hi:

I am trying to create a stored procedure that filters some customers. The field in wich I am trying to apply the filter is the age field. The problem is that I need to be able to select the comparison operator =,<,>,=<,>=,<>.
I was trying to do it with the following code:

Select CustomerName From Customer Where
(CustomerAge & @Operator & @Age)

But sql Server shows an error telling me that @Operartor couldnt be converted to int.

I dont know if I am in the right track or way off, how is this done?

 

[giadich]

you have to create dynamic sql statement and execute it.

Exec ('Select CustomerName From Customer Where CustomerAge ' & @Operator & @Age)