LIKE with case sensitive wildcards

Question

I've got the following query:

Click to copy

SELECT *
FROM sys.objects AS O
WHERE O.is_ms_shipped = 0
AND O.name LIKE '%[A-Z][A-Z][A-Z]%' COLLATE Latin1_General_CS_AS;

This is supposed to find all objects within the database that have at least three consecutive capital characters, however it doesn't seem to work and I'm not really sure why. I've tried to list all characters explicitly instead of specifying range, but it didn't solve the problem.

Sample data:

Click to copy

name
---------
HTMLTable
HtmlTable

Desired output:

Click to copy

name
---------
HTMLTable

Answer 1

Try this instead:

Click to copy

LIKE '%[A-Z][A-Z][A-Z]%' COLLATE Latin1_General_Bin

Answer 2

The below code should work -

Click to copy

SELECT name
FROM sys.objects AS O
WHERE O.is_ms_shipped = 0
AND O.name LIKE '%[ABCDEFGHIJKLMNOPQRSTUVWXYZ][ABCDEFGHIJKLMNOPQRSTUVWXYZ][ABCDEFGHIJKLMNOPQRSTUVWXYZ]%' COLLATE Latin1_General_CS_AS;