RE: Convert Function in Informix

Gentlemen: I've been following this thread with some interest and I've seen at least two posts stating Informix does the conversion automatically. That is correct, but if speed is an issue is speed you might loose your index: Look for a full table scan, especially if you're going an integer to CHAR conversion. regards, Ed Schaefer In <5k508a$spi@cssun.mathcs.emory.edu> Tom@oncontact.com ("Boldt, Thomas") writes: > > >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 >>