Ed Reed wrote:
But if the user happens to put a numeric value within the text somewhere then UCASE and UPPER both fail to convert the text to upper case.
Can you give an example? I think there's something else going on that you're overlooking. UPPER() and UCASE() (which are synonyms for the same function) uppercase all letters in the string. They don't care whether there are numbers in it.
mysql> select UPPER('abc123def');
+--------------------+
| UPPER('abc123def') |
+--------------------+
| ABC123DEF |
+--------------------+
1 row in set (0.05 sec)
-- Keith Ivey <[EMAIL PROTECTED]> Smokefree DC http://www.smokefreedc.org Washington, DC
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
