Hi :
I want to convert a char column to a num type;
I don't known which internal function can be used!
Sample :
select to_num( char_column_name ) from my_table;

Thanks!

select char_col::INT
from eric

will work in the 9 engines

or

select char_col + 0
from eric

in the earlier engines

Killwind wrote:
--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #