Re: How do you covert a number a character

> I'd not want to guarantee that -- in fact, I rather suspect that it > converts the string to integer, and that is what is causing the Q. > In 5.00 and above, using || to concatenate an empty string to the > integer field should force the conversion to string, but I'd not want > to guarantee the resulting speed. > > Yours, > Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> I have to admit I hadn't considered the possibility that it might do it the other way around. I've always been under the impression that it converted everything to character before comparing different types. Looking back on it I can't remember where I got that from. If it does as Jonathon suggests you could just as easily get a type conversion error instead of a comparison depending on what was in your character field. Not exactly a pleasant result. 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 ----------------------------------------------------------------------