Oninit cdi / Archive
Talk to an expert →

Re: Converting character column to upper case

Posted in 2004

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

Candy McCall — — source: Usenet: comp.databases.informix

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

↪ replying to Candy McCall
June C. Hunt — — source: Usenet: comp.databases.informix

Candy McCall wrote: > > It doesn't appear to work in SE (standard engine). > Any other ideas? There may be other suggestions coming, but the only thing I could find with a brief look at c.d.i. and the IIUG software archive is a procedure called 'newupper'. That one is available at the IIUG site. There was at least one other sample procedure (function) listed in some c.d.i. threads. Other than those suggestions... I'm at a loss. HTH > ----- 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

Glossary