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 it. 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. Is
there a way to force it to do so for the alpha characters?
Thanks
