MS SQL implementation verifies that strings contain uppercase and lowercase features _ Practical tips

MS SQL implementation verifies whether a string contains uppercase and lowercase features

A small feature was implemented last night, in MS SQL Server, to check whether the string contains uppercase and lowercase letters. Usually applied to the complexity of the string.

DECLARE @s NVARCHAR (+) = N ' Sdffggryjhhtyuj '


IF LOWER (@s), COLLATE latin1_general_cs_as <> @s and UPPER (@s) Colla TE latin1_general_cs_as <> @s
  print '
ELSE
  print ' F '

Real-time Operation demo, empty string, all lowercase, all uppercase, the size of mixed write status:

Thank you for reading, I hope to help you, thank you for your support for this site!