I am using MSquery,and I want to convert the char result to number or integer....I tried using convert(value,data type),to_number(value)....and nothing worked.Someone please let me know which function to use.
Thanks

Hi,

in DB2 SQL, you can try the functions

INTEGER( 'yourcharrep' ) or
DOUBLE( 'anothernumber' )

Also available are BIGINT, FLOAT, REAL.

Johann