[snip]
I want to convert the whole thing to upper case so I can do a case
insensitive compare against it.
[/snip]
If you want to do a case insensitive comparison against the data then
there is no need to convert to upper case.
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
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