How to convert the CHAR type to NUM in the select?

Posted in 2003

Killwind — Sat, 13 Sep 2003 10:58:38 +0800 — source: Usenet: comp.databases.informix

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!

↪ replying to Killwind

Paul Watson — Sat, 13 Sep 2003 10:14:17 +0100 — source: Usenet: comp.databases.informix

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: > > 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! -- 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 #