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>
<P><FONT SIZE=3D2>Candy,</FONT>
</P>
<P><FONT SIZE=3D2>This works in version 9.40.FC3</FONT>
</P>
<P><FONT SIZE=3D2>update table_name set col_name =3D =
UPPER(col_name) </FONT>
<BR><FONT SIZE=3D2>where =
1=3D1 &=
nbsp; &=
nbsp; &=
nbsp; </FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Brian</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Candy McCall [<A =
HREF=3D"mailto:candym@olcinc.com">mailto:candym@olcinc.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, August 27, 2004 2:57 PM</FONT>
<BR><FONT SIZE=3D2>To: Informix List</FONT>
<BR><FONT SIZE=3D2>Subject: Converting character column to upper =
case</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>I have an easy question (hopefully).</FONT>
<BR><FONT SIZE=3D2>Is there a function in SQL to convert </FONT>
<BR><FONT SIZE=3D2>all characters of a column to uppercase?</FONT>
<BR><FONT SIZE=3D2>I know in 4GL you can use upshift.</FONT>
</P>
<P><FONT SIZE=3D2>Thanks!</FONT>
</P>
<P><FONT SIZE=3D2>Candy</FONT>
<BR><FONT SIZE=3D2>--</FONT>
<BR><FONT SIZE=3D2>Candy McCall</FONT>
<BR><FONT SIZE=3D2>ONLINE Computing, Inc.</FONT>
<BR><FONT SIZE=3D2>(candym@olcinc.com)</FONT>
<BR><FONT SIZE=3D2>www.onlinemastertools.com</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>sending to informix-list</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C48C6D.24C83140--
sending to informix-list