Converting character column to upper case

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Candy McCall - 27 Aug 2004 19:56 GMT

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

Reply to this Message

June C. Hunt - 27 Aug 2004 20:25 GMT

> 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

Reply to this Message

Brian Minnick - 27 Aug 2004 20:36 GMT

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C48C6D.24C83140
Content-Type: text/plain;
charset="iso-8859-1"

Candy,

This works in version 9.40.FC3

update table_name set col_name = UPPER(col_name)
where 1=1

Brian

-----Original Message-----
From: Candy McCall [mailto:candym@olcinc.com]
Sent: Friday, August 27, 2004 2:57 PM
To: Informix List
Subject: Converting character column to upper case

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

------_=_NextPart_001_01C48C6D.24C83140
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.45">
<TITLE>RE: Converting character column to upper case</TITLE>
</HEAD>
<BODY>

Candy,


This works in version 9.40.FC3


update table_name set col_name =3D =
UPPER(col_name)  
 where =
1=3D1           &=
nbsp;           &=
nbsp;           &=
nbsp;     

 

Brian


-----Original Message-----
 From: Candy McCall [<A =
HREF=3D"mailto:candym@olcinc.com">mailto:candym@olcinc.com</A>]
 Sent: Friday, August 27, 2004 2:57 PM
 To: Informix List
 Subject: Converting character column to upper =
case

 

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


</BODY>
</HTML>
------_=_NextPart_001_01C48C6D.24C83140--
sending to informix-list

Reply to this Message

Candy McCall - 27 Aug 2004 20:40 GMT

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:
> >
[quoted text clipped - 7 lines]
> --
> June Hunt

sending to informix-list

Reply to this Message

Rob Vorbroker - 28 Aug 2004 00:01 GMT

What version are you running?

> It doesn't appear to work in SE (standard engine).
> Any other ideas?
[quoted text clipped - 21 lines]
>
> 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

Reply to this Message

Candy McCall - 28 Aug 2004 16:34 GMT

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?
>
[quoted text clipped - 30 lines]
> Vorbroker Consulting, Inc. Fax: 513/336-6812
> www.vorbroker.com robv@vorbroker.com

sending to informix-list

Reply to this Message