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 to

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