Converting character column to upper case

Posted in 2004

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

Candy McCall — Fri, 27 Aug 2004 13:56:53 -0500 — source: Usenet: comp.databases.informix

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. Thanks! Candy -- Candy McCall ONLINE Computing, Inc. (candym@olcinc.com) www.onlinemastertools.com sending to informix-list

↪ replying to Candy McCall

June C. Hunt — Fri, 27 Aug 2004 15:25:32 -0400 — source: Usenet: comp.databases.informix

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

4GL (Informix-4GL)