Re: Character to number conversion

Select TO_NUMBER( field_a ) From table_a;

Norazman Sahir wrote in message <36E425F4.EB5213D3_at_ti.com>...
>Hi All,
>
>I have a problem here.
>In my table, the column datatype is character.
>However, the data is always number (don't ask me why, I'm not
>the one who create the system). My question is:
>Is there any way I can convert character to number. I'm
>having a problem while tring to do a calculation on it
>(like sum etc....which not allowed for character dayatype)
>Appreciate any help. Many thanks.
Received on Mon Mar 08 1999 - 18:56:04 CET