Need to hide prices with a 0.00 price
I am in a position where I receive CSV files to import products into the DB. It's very unlikely that the client will update thousands of prices one at a time via the CMS.
Due to poor integrity of their data in the CSV files some prices are missing for products, and as a result, they get set to 0.00. Obviously any product being sold at that price is a no no, so I need to hide the product until it's given a price.
I am trying to add this to the query of the results page and product page:
AND ProductPrice <> 0.00
but it's not working.
Where am I going wrong?