sql - TSQL Select national characters issue with the range

Question

I'm on SQL Server 2016 with default settings, and can't understand whey this line 4 doesn't catch my weird character ? which A with the roof. It's matched by [a-z] range, never thought that it would be the case. Is the any solution to work it out with the range ? In my example below I expect to display single record, but line 4 doesn't allow me do so. Is line 5 with the list the only solution??? Interesting that CHAR(13) is of of the range and works fine.

DECLARE @a VARCHAR(10) = CHAR(13) +'Delta',   @b NVARCHAR(20) = '?' + 'Hotel';
SELECT @a A, LEN(@a) LenA, @b B, LEN(@b) LenB  
       ,CASE WHEN @b < 'A' THEN 'LessA'  ELSE CASE WHEN @b > 'Z' THEN 'GreaterZ' ELSE  '? Between' END END sw
WHERE 1=1
AND    @b NOT LIKE  '[A-Z]%'             --- Line 4:   <<< '?'   in the range [a-z] or [A-Z] , how I can only work with 26 English letter range ???
-- AND    @b NOT LIKE  '[ABCDEFHGW]%'    --- Line 5:   <<< is writing the list the only solution ?
-- AND    @b LIKE '?%' 
-- COLLATE Latin1_General_CS_AS

Answer 1

等待大神答复