Getting A Price Range

I am trying to get a price range so my visitors can view my products within a certain price.

For example:

Click here for products $10 - $25
and so on...

Here is what I have so far but it doesn't seem to be doing the trick:


select * from products WHERE Price = '10.00' || Price <= '25.00'

select var1, var2 from products WHERE Price BETWEEN 10 and 25

--> never use a * in embedded sql (always specifythe columns)
--> price should be an indexed, numerical column to speed up the searches

Thank you for the help :)

You're welcome :thumbsup: