Convert a number charactor to number, Oracle has to_number, does .

R

Rick B

please post your entire question. It is customary to use the large section
of the form, not just the subject field.
 
B

Brian Camire

You might use one of CByte, CDbl, CDec, CInt, CLng, CSng, depending on what
type of number you want to convert to.

Unlike TO_CHAR, you cannot specify the format model. Instead the functions
do the conversion based on the locale setting of the computer.
 
Top