SQL Query with Radio Buttons

[virtual1]

I'm running a search from my web page with multiple criteria. One of the
criteria is a section called Pay Range. I have radio buttons set up for the
following options: Range 1 2 3 4 Any I can match up a result from the
database if their is a candidate with a pay range of either 1, 2, 3, or 4. But
how do I pass along to the query that range doesn't matter if 'Any' is
selected. Is there some sort of 'IF' type statement or logic that I can
build into my SQL query to ignore this criteria if 'ANY' is selected? Thank you

[Chris Seymour]

Hello,
You have a couple of options. When you are building the SQL if the
visitor selects any you can leave the criteria for range out or you can
use a wildcard to select any range. It really depends on your comfort
level and database.

If you need a hand, feel free to drop me a line.

Thanks.

Chris
virtual1 wrote:

> I'm running a search from my web page with multiple criteria. One of the
> criteria is a section called Pay Range. I have radio buttons set up for the
> following options: Range 1 2 3 4 Any I can match up a result from the
> database if their is a candidate with a pay range of either 1, 2, 3, or 4. But
> how do I pass along to the query that range doesn't matter if 'Any' is
> selected. Is there some sort of 'IF' type statement or logic that I can
> build into my SQL query to ignore this criteria if 'ANY' is selected? Thank you
>