> I use CONVERT expression1 TO expression2 IN variable
Don't use CONVERT! Example:
CRT CONVERT( 'Muffet', 'Piggy', 'Little Miss Muffet sat on a tuffet
eating her curds and whey.' )
yields the string:
Lily Piss Piggy sa on a iggy yaing hyr cirds and whyy.
which is offensive enough even for those of us who don't speak Welsh.
P.S. Last week I said "REPLACE()" instead of "CHANGE()" in the
I've corrected it ( i.e., CHANGE( 'REPLACE()', 'CHANGE()', MSGBODY ) )
From: Stevenson, Charles
Sent: Thursday, April 22, 2004 2:41 PM
To: 'U2 Users Discussion List'
Subject: RE: How do we convert lowercase letters to uppercase in Pick
and just cuz no one mentioned it ( not cuz it's better than UPCASE() &
CONVERT does character for character swapping:
CONVERT 'abcdefghijklmnopqrstuvwxyz' TO 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
in ANYSTR and
CONVERT 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' TO 'abcdefghijklmnopqrstuvwxyz'
UPSTR = CONVERT( 'abcdefghijklmnopqrstuvwxyz',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ', ANYSTR ) and
DNSTR = CONVERT( 'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
'abcdefghijklmnopqrstuvwxyz', ANYSTR ) depending on your mood.
Note the difference between CHANGE() & CONVERT().
Use CHANGE() to replace an entire substring with another substring.
CONVERT does char by char. A common misconception.
u2-users mailing list