Re: CASTING

Posted in 2003

Art S. Kagel — Tue, 15 Jul 2003 16:52:32 -0400 — source: Usenet: comp.databases.informix

On Tue, 15 Jul 2003 02:52:54 -0400, Anton wrote: > How could I compare two fields one of which is of integer type, the > other is char? The version of the INFORMIX is 7.2. Thanks in advance. Where? In an SQL statement? If the char column only contains numeric characters you can compare the two columns directly the engine will decide the most efficient conversion (char->int or int->char) for the comparison based on the tables and statistics. In 9.xx you can use a cast: WHERE char_col = CHAR::int_col Art S. Kagel

Related threads

Different instances with markedly different times