Re: How do you covert a number a character

From Jim Gordon: * > 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? * * 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. * Wrong. It tries to convert character to integers. Robert Minter |Data Systems Support| \\\\\\_/// Programmer, Software Development | Orange, CA | ( _ _ ) rob@dssmktg.com | Tel: 714.771.0454 | (| ^ |) De Colores - Emmaus OC-13 | Fax: 714.771.3028 | \\`-'/ #include <disclaimer.h> SURF'S UP \\_/