Lower Case Letters 1

[acct98]

Does anyone have a script to search for lowercase letters in a sting?

 

[carp]

Do you want to identify individual letters or just determine whether or not a string has lower case letters in it?

If the latter, then

SELECT primary_key_column, string_column
FROM my_table
WHERE string_column != UPPER(string_column);

ought to do it.

Elbert, CO
1654 MST

 

[acct98]

Thanks