Re: SQL function to convert a string to upper-case

Posted in 1996

Nils Myklebust — Mon, 23 Sep 1996 09:03:24 GMT — source: Informix-list mailing list archive (1991-1998)

Ashi Chaturvedula <ashi@thomtech.com> wrote: :hi folks, :I am new to the Informix World; Is there a SQL function in Informix SQL :that converts a varchar data to all uppercase ( similar to Oracle's :UPPER/INITCAPS function)? :For eg. :select first_name,last_name :from user_information :where UPPER(first_name)=upper('Joe Blo'); No direct way, but check out the FAQ at www.iiug.org Nils.Myklebust@idg.no <- New E-mail adress NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company