How would I include zero values in a numerical range search?
Hi there, I have a database search up and running which includes a price comparison feature, so the user chooses from a minimum and maximum price, and results within those parameters are returned. Here's the code for it for the form fields minPrice and maxPrice:
My customer sometimes has items that are set as 'Price on Application', and in this case there is a zero in the price field in the database. Is there a way that I can make it so that all results within minPrice and maxPrice AND all results with a price of 0 are returned in the result?