Locate upper case characters in SQL Server database field

Question

I need to locate rows in a database table that have a field with an upper case value.

E.g.: select * from Cust where Surname like 'COnTAiNS UpPERcASE VaLUeS'

Any assistance would be appreciated.

AJ

Answer 1

You can do a binary comparison using:

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