Use the to_number() function to convert text to numbers.
In the manual under functions and operators. The other
function like it is to_date().
--elein
elein@varlena.com
On Fri, May 05, 2006 at 02:37:13PM -0700, Kashmira Patel (kupatel) wrote:
> Hi all,
> I have a table with a column of type 'text'. It mainly contains numbers. Is
> there any way to select a value from this column and return it as an integer?
>
> Thanks,
> Kashmira