Re: Converting character column to upper case

What version are you running? --- Candy McCall <candym@olcinc.com> wrote: > It doesn't appear to work in SE (standard engine). > Any other ideas? > > Candy > > ----- Original Message ----- > From: June Hunt - Auto Europe <Juneh@autoeurope.com> > To: <candym@olcinc.com> > Sent: Friday, August 27, 2004 2:26 PM > Subject: Re: Converting character column to upper > case > > > > Candy McCall wrote: > > > > > > I have an easy question (hopefully). > > > Is there a function in SQL to convert > > > all characters of a column to uppercase? > > > I know in 4GL you can use upshift. > > > > Try the UPPER function. > > > > -- > > June Hunt > > > > > > sending to informix-list > ===== Rob Vorbroker Phone: 513/336-8695 Vorbroker Consulting, Inc. Fax: 513/336-6812 www.vorbroker.com robv@vorbroker.com sending to informix-list

Rob Vorbroker wrote: > What version are you running? It doesn't matter - UPPER was added to IDS at the 7.3x level (7.30, IIRC, but not sooner). Put simplistically, SE is still at a 7.2x level and doesn't have UPPER. You can, just about, code an UPPER function in SPL for SE, but the code is excruciating for a variety of reasons -- and anything but fast. If you need the server to do it, probably time to say goodbye to SE; sad, but so. Otherwise, have the applications do it. >Candy McCall <candym@olcinc.com> wrote: >>It doesn't appear to work in SE (standard engine). >>Any other ideas? >>>From: June Hunt <Juneh@autoeurope.com> >>>Candy McCall wrote: >>>>I have an easy question (hopefully). >>>>Is there a function in SQL to convert >>>>all characters of a column to uppercase? >>>>I know in 4GL you can use upshift. >>> >>>Try the UPPER function. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/