The following was put together in DMX but I wish to be able to also allow for the optional "All" or "Any" search from the "Suburbs" column. In other words I want to give users the option to select "All" and have all the suburbs displayed as apposed to selecting one at a time. Any help will be much appreciated!

SELECT Listing, Type, City, Suburb, Price, Bedrooms, Bathrooms, OnSuite
FROM Main
WHERE Price BETWEEN varPrice1 AND varPrice2 AND Suburb = 'varSuburb' AND Type = 'varType' AND City = 'varCity'

varPrice1 0 Request.Querystring("Price1"
varPrice2 0 Request.Querystring("Price2"
varSuburb % Request.Querystring("Suburb"
varType % Request.Querystring("Type"
varCity % Request.Querystring("City"