How SQL Server determines that a field contains uppercase letters

The default in SQL statements is case-insensitive, so the statement:

SQL code
SELECT * from recenginebizinfo WHERE recenginebizname = ' QQ '
And
SQL code
SELECT * from recenginebizinfo WHERE recenginebizname = ' QQ '

The results are the same.

The script to see if a field contains uppercase A is:
SQL code
SELECT * from Recenginebizinfo where recenginebizname collate chinese_prc_cs_as_ws like '%a% '
Www.jb51.net
The script to see if a field contains uppercase letters is:
SQL code
SELECT * from Recenginebizinfo Rebi
WHERE Rebi. Recenginebizname COLLATE Chinese_prc_cs_as
Like '%[abcdefghijklmnopqrstuvwxyz]% '

To see if a field contains a script with two uppercase letters in a row:
SQL code
SELECT * from Recengineattributeinfo Reai
WHERE Reai. Zhiling COLLATE Chinese_prc_cs_as
Like '%[abcdefghijklmnopqrstuvwxyz][abcdefghijklmnopqrstuvwxyz]% '

In turn.

How SQL Server determines that a field contains uppercase letters