Query to find rows with upper case characters.

[fal762]

Hi all. I'm using SQL Server 2000 and have a large table with a varchar field containing email addresses. I need to find those rows whose email address any upper case letter in any position in the address. Other than running a query for each upper case letter is there a better way to find such rows.

Thanx.

 

[nigelrivett]

select *
from tbl
where email like '%[A-Z]%' collate Latin1_General_CS_AI

You can miss out the collate if you are case sensitive.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.