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 [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
