> 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.

cds

P.S.  Last week I said "REPLACE()" instead of "CHANGE()" in the
following post.
I've corrected it ( i.e., CHANGE( 'REPLACE()', 'CHANGE()', MSGBODY ) )
here: 

-----Original Message-----
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
basic


and just cuz no one mentioned it ( not cuz it's better than UPCASE() &
DOWNCASE() ),

CONVERT does character for character swapping:
   CONVERT 'abcdefghijklmnopqrstuvwxyz' TO 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
in ANYSTR and
   CONVERT 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' TO 'abcdefghijklmnopqrstuvwxyz'
in ANYSTR

 or

   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
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to