How do I check for lower- or uppercase characters in a 30-byte character string?
QUESTION POSED ON: 25 JUL 2005
QUESTION ANSWERED BY: Rudy Limeback
This depends on which database system you're using; they don't all have the same string functions like LOWER or LCASE.
Here's a WHERE clause condition that would tell you if there are any lowercase characters:
... where upper(foo) <> foo
|
