Re: case insensitive select

Posted in 1999

Obnoxio The Clown — Mon, 11 Oct 1999 12:23:11 BST — source: Informix-list mailing list archive (1991-1998)

From: "Carol" <carol.hui@startvision.com> > >UPPER(cust_name) is not found in the informix SQL. Then, how can i get a >case insensitve select statement? It is in IDS version 7.30 or greater. Alternatively, you can get stored procedures from http://www.iiug.org that will do the same thing, albeit slower. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com