RE: Converting character column to upper case
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