How do we convert lowercase letters to uppercase in Pick basic

Hi, Can some one tell me how to convert lower case letters to uppercaseand vise versa tx in advance for the help regards reddy -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: @SPAM++++++ How do we convert lowercase letters to uppercase in Pick basic

t: (44) 1564 777011 f: (44) 1564 739610 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: 22 April 2004 20:11 To: [EMAIL PROTECTED] Subject: @SPAM++ How do we convert lowercase letters to uppercase in Pick basic Hi, Can some one

Re: How do we convert lowercase letters to uppercase in Pick basic

ICONV or OCONV(fieldname,'MCL') uppercase to lowercase ICONV or OCONV(fieldname,'MCU') lowercase to uppercase Ron White - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 22, 2004 2:11 PM Subject: How do we convert lowercase letters

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