RE: Convert Function in Informix

Dean, I am not aware of a convert function, but you can add 0 to what you're selecting: select string_col + 0 from ....... This will cause implicit conversion to numeric data type. If you do not like what the output looks like try select into a temp table in which the destination column is in the format you need. Tom Boldt on!Contact Software Corporation "Adaptable Solutions for Today's Sales Organization" mailto:tom@oncontact.com http://www.oncontact.com >---------- >From: dean_c@tst.hk.super.net[SMTP:dean_c@tst.hk.super.net] >Sent: Monday, April 28, 1997 11:43 PM >To: informix-list@rmy.emory.edu >Subject: Convert Function in Informix > >Does anyone know whether there is an internal convert function in Informix >to convert string value to numeric value in the SQL statement (without >using 4GL & ESQL/C ie the SQL statement can be run in dbaccess)? > >Besides, how can i execute the SQL statement under the Unix command line >(IBM AIX machine)? Please give me the exact syntax ... > >Thanks > >Dean Cheuk >dean_c@hk.super.net >