Re: Character to number conversion

From: <dejaron_at_my-dejanews.com>
Date: Tue, 09 Mar 1999 20:43:21 GMT
Message-ID: <7c4156$1ak$1@nnrp1.dejanews.com>

Have you tried the TO_NUMBER built-in function?

In article <36E4261C.F3B4241D_at_ti.com>,
norazman_at_ti.com wrote:
> 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.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 09 1999 - 14:43:21 CST