Re: How do you covert a number a character

> A co-worker is trying to do a query in ISQL in which he wants to compare > a number field with a character field. The character field could > either contain digits or could be a mixture of characters and > digits. What he wants to do is to convert the number to a character > string before doing the comparison. Is there a way to do the conversion? > Or, is there another way to do the comparison? > > Thanks. > > -- Joe You don't have to. Informix will handle the data conversion problem for you. Just write int-field = char-field and it will automatically convert the integer field to character. The field will have leading zeros so the character version must also have leading zeros to get a match. Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Company: DHL Systems Inc, Burlingame, CA, USA ----------------------------------------------------------------------