can't cast char to in - Mailing list pgsql-general

I have a table with a mileage column that is a character varying (please don't ask why :).

I need to do a query where mileage > 500

select * from cars where mileage>500

So I need to cast it but everything I try throws an error such as :

ERROR:  invalid input syntax for integer: "+"

How can I cast this?



Thanks!