hanks, charlys. Pady py day. >>> [EMAIL PROTECTED] 4/27/04 12:55:39 PM >>> > 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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users