Re: Converting character column to upper case

Posted in 2004

Candy McCall — Sat, 28 Aug 2004 10:34:26 -0500 — source: Usenet: comp.databases.informix

7.24UC5 ----- Original Message ----- From: Rob Vorbroker <rvorbroker@yahoo.com> To: Candy McCall <candym@olcinc.com>; Informix List <informix-list@iiug.org> Sent: Friday, August 27, 2004 6:01 PM Subject: 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