Take the 2-minute tour ×  My server's default collation is
Latin1_General_CI_AS, as determined by this query:  SELECT
SERVERPROPERTY('Collation') AS Collation;  I was surprised to
discover that with this collation I can match non-digit
characters in strings using the predicate LIKE '[0-9]'.  Why in
the default collation does this happen? I can't think of a case
where this would be useful. I know I can work around the
behavior using a binary collation, but it seems like a strange
way to implement the default collation.  Filtering digits
produces non-digit caracters  I can demonstrate the behavior by
creating a column that contains all possible single-byte
character values and filtering the values with the digit-
matching predicate.  The following statement creates a temporary
table with 256 rows, one for each code point in the current code
page:  Tally(Number) AS ( SELECT Number AS CodePoint,
CHAR(Number) AS Symbol INTO #CodePage FROM Tally WHERE Number >=
0 AND Number <= 255;  Each row contains the integer val