Re: Uppercase in SQL

From: Aleksandr Shneyderman <alex@law.columbia.edu> > >select upper(<field name>) from <table name> > >Michael Brizendine wrote: > > > Hey all, > > > > Is their a function available for returning the uppercase of a character > > string in an SQL statement. I thought there was but I may just be > > thinking of 4gl. I'm on solaris and Informix 7.24. Thanks in advance. I think the UPPER function is only built into 7.3 and greater. You'll have to write a stored procedure in earlier versions. You can find a sample at http://www.iiug.org ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com