Re: Cast char to number

On 24/02/2010 21:42, Christine Penner wrote:
> This is what I did.
>
> set all blank columns to '0' because they were causing errors.
> alter table T alter column a type integer using a::integer
>
> That worked perfectly.

Glad you got sorted.

Bill's advice upthread is worth taking on board - if you're in a
position to do so, make sure that numbers are stored as numbers rather
than text, and you'll save yourself all sorts of wacky grief.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie