find any character in a string that is a lower case

in SQL Server 7, How can I find out if a database field has any lower case
character in the string. Thanks!

you can create a temp table w/ the letters of the alphabet in it and
search that field IN #temp table.

or you could find a length of the string and then substring letter by
letter and search the ASCII values for each lowercase letter against
the substring letter.

Thanks! What I did is to find the sum of the ASCII values for the whole
string and the sum of ASCIIs for upper(string) at the same time. If they are
not equal, there is a lower case character.

"GlennThomas5" wrote:

> you can create a temp table w/ the letters of the alphabet in it and
> search that field IN #temp table.
>
> or you could find a length of the string and then substring letter by
> letter and search the ASCII values for each lowercase letter against
> the substring letter.
>
>