Re: Data type conversion in query

Posted in 2000

Obnoxio The Clown — Tue, 04 Jul 2000 11:07:45 BST — source: Informix-list mailing list archive (1991-1998)

From: "Anthony Judish" <ajudish2@home.com> > >Does anyone out there know how to force the optimizer/engine to convert >data >types in a query? I have a query that is joining a CHAR(20) column to an >INTEGER column. Right now it is trying to convert the CHAR to an INTEGER >which won't work. If I could make it convert the INTEGER to a CHAR it would >work. Well, duh...why are you trying to match an INT against a CHAR? SELECT int_val || "", char_val FROM int_table, char_table WHERE int_val || "" = char_val *might* work. I don't agree with what you're trying to do. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com