check if a string contains small letter in sql

select patindex('%[a-z]%'    COLLATE Latin1_General_BIN,'test')

select patindex( '%es%'    COLLATE Latin1_General_BIN,'Test')