Ms SQL to verify whether a string contains uppercase and lowercase letters, including uppercase and lowercase letters

Ms SQL to verify whether a string contains uppercase and lowercase letters, including uppercase and lowercase letters

Ms SQL to verify whether a string contains uppercase/lowercase letters

Last night, a small function was implemented to check whether the string contains uppercase and lowercase letters in ms SQL Server. The complexity of string is usually applied.

DECLARE @ s NVARCHAR (40) = n' SDFfgGRYJhhTYUJ 'if lower (@ s) COLLATE Latin1_General_CS_AS <> @ s and upper (@ s) COLLATE Latin1_General_CS_AS <> @ s PRINT 't'else PRINT 'F'

Real-time operation demonstration, with a Null String, all lowercase letters, all uppercase letters, and mixed size:

Thank you for reading this article. I hope it will help you. Thank you for your support for this site!