[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
Is there anyway to force UCASE and UPPER to convert the alpha characters of a
string even if there's a number in the string somewhere?
I have a field that contains large amounts of user entered text. I want to
convert the whole thing to upper case so I can do a case insensitive compare
against
