Yes, of course by a stored proc, sorry for errors )) The simplest architecture I am considering is the python client application is running on the same machine and there...

Someone without a surname has to be a good fortuneteller to make predictions using a last name

Thanks for your explanations

This behavior:

SELECT V.String,
       CASE WHEN V.String COLLATE Latin1_General_100_BIN LIKE '%[a-z]%' THEN 'Yes' ELSE 'No' END AS ContainsLowerCase
FROM (VALUES('This has lowercase letters'),('THIS...

Should this be considered as an error in earlier collations before 100?

• This reply was modified 5 years, 7 months ago by  Peter Shilovich.

As I know, there is no true REGEX in SQL Server. Is the method to solve the question with "like" and wildcard?

Thanks!

Perhaps, I did not put the question clearly. The initial question is how to check whether the string contains lower case letters.

I don't want to store pass in plain text. I would like to check it strength in DB and then hash it as I wrote in the first post.

Ok, let's put aside password storing. I just would like to check whether lower or upper case letters exists in a string and distinguish them.

You may see the warning in the execution plan

I've just updated both statistics. The result is the same.