select empid, lastname
from HR.Employees
where lastname COLLATE Latin1_General_Cs_AS = LOWER(lastname);
In this problem I wanna to find last names in which starts with lower case letter so,
I use from COLLATE that is Case sensitive(Cs) and Accent sensitive (As).