i need help with a query for a meta key 'price' the problem is i need it to display 15 posts per page, and the real pain is the prices are entered into the database with $'s and commas, ie. $5,000. we want to be able to perform a query for price ranges and have them display asc ie. an "under 50$" query would display all posts with a meta key price under $50... there are also prices entered as "$TBD" "$ Upon Request", we need to exclude those from the results.
thanks in advance