SQL - Using parameters

[reachpradeep]

Hi all, I know I could do something like this in SQL:


select customers.name
from customers
where customers.name = request.form("txtname")


but my question is, can I have a user pick the operator (such as =,>,<,>=,<=) from a dropdown box and pass it the the sql statement as a parameter such as:

select customers.name
from customers
where customers.name request.form("txtoperator") request.form("txtname")

Please help!