>Hi Al Doman,
>
> Is there anyway to do it without UPPER() and LOWER() function?
>
>Thank you
>Aston Mak
For the alphabetical characters A-Z, the uppercase are separated from the lower case by 32. Look at the ASC() function:
ASC("A") = 65
ASC("a") = 97
ASC("B") = 66
ASC("b") = 98
etc.
HTH
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up