CREATE DATABASE qod_collation_db COLLATE Japanese_CI_AS_KS_WS;
GO
USE qod_collation_db;
GO
WITH Numbers AS
(  SELECT 0 AS n
   UNION ALL
   SELECT n + 1
   FROM Numbers
   WHERE n <= 255
)
SELECT n AS code, CHAR(n) AS symbol
FROM Numbers AS n 
WHERE CHAR(n) COLLATE Latin1_General_CI_AS BETWEEN '0' AND 'Z'
OPTION(MAXRECURSION 256);
GO
USE master;
GO
DROP DATABASE qod_collation_db;
GO

SELECT * 
FROM dbo.Numbers AS n 
WHERE 
    CHAR(n) COLLATE Latin1_General_CI_AS 
        BETWEEN '0' AND 'Z';

select CHAR(I),I from Tally 
    where char(I)  between '0' and 'Z' collate latin1_general_ci_as 
    and I < 256 order by CHAR(I) 

SELECT ASCII('Z')-ASCII('0')