can't cast char to in

------=_Part_8865_30702476.1208878457774
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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!

------=_Part_8865_30702476.1208878457774
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I have a table with a mileage column that is a character varying (please
don&#39;t ask why :).<br><br>I need to do a query where mileage &gt;
500<br><br>select * from cars where mileage&gt;500<br><br>So I need to
cast it but everything I try throws an error such as :<br>
<br><pre class="data">ERROR:  invalid input syntax for integer:
&quot;+&quot;<br><br>How can I cast
this?<br><br><br><br>Thanks!<br></pre><br>

------=_Part_8865_30702476.1208878457774--