MSSQL SQL Server method for determining string case sharing

Summary:
The following is a method of using SQL script to determine how the string is case-sharing, as shown below
Lab environment: SQL Server R2
Implementation ideas:
Converts a string to uppercase or lowercase and then converts to a binary encoding,
Then compare it to the source string.

/*Example: String case method Sharing*/Declare @str varchar( -)Set @str ='www.maomao365.com'--------------------------------------------------------------if Convert(varbinary,@str)= Convert(varbinary,Lower(@str)) beginPrintN'the strings are lowercase!'EndElse if Convert(varbinary,@str)= Convert(varbinary,Upper(@str)) beginPrintN'the strings are all uppercase!'EndElse beginPrintN'the strings are mixed in size!'End

Original address: http://www.maomao365.com/?p=7358

MSSQL SQL Server method for determining string case sharing