Locate upper case characters in SQL Server database field

This is work for me

SELECT * FROM agents 
WHERE  email REGEXP BINARY  '[A-Z]'

You can do a binary comparison using:

select *
from Cust
where cast(Surname as varbinary(120)) != cast(lower(Surname) as varbinary(120))

Another way

SELECT *
FROM Cust
WHERE Surname NOT LIKE '%[^A-Z]%' COLLATE Latin1_General_BIN

Related