Re: Integer to String Evaluation in SQL Statement

June Tong wrote: > > Mark D. Stock wrote: > > > Try something like: > > > > SELECT * > > FROM my_table > > WHERE col1 || "" LIKE "%5678%"> > > > Of course, this type of wildcard query could still be slow. > > or > WHERE TO_CHAR(col1) LIKE "%5678%" > if you have 7.30+ Yes, but these built-ins are SO slow! I was trying to use NVL the other day and gave up! Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+