hi all a total newbie here first week with this stuff.

I got a html form that passes info to asp page.
select name="price"
option value="200" $0-$200 /option
option value="400" $200-$400 /option
/select

SQL = "SELECT * FROM table WHERE price<"&Request.Form("price")&"

if select option value="400" it shows all items less than 400 when i only want to display items from 200-400.

Is this making sense. Do i need some vb script somewhere to make this work or is the SQL wrong

Cheers
newbie