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' COLLATE Latin1_General_CI_AS AND 'Z' COLLATE Latin1_General_CI_AS
OPTION(MAXRECURSION 255);
GO
USE master;
GO
DROP DATABASE qod_collation_db;
GO

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, cast(NCHAR(n) COLLATE Latin1_General_CI_AS as CHAR(1))  AS symbol
FROM Numbers 
WHERE cast(NCHAR(n) COLLATE Latin1_General_CI_AS as CHAR(1)) 
    BETWEEN '0' COLLATE Latin1_General_CI_AS AND 'Z' COLLATE Latin1_General_CI_AS
OPTION(MAXRECURSION 255);
GO
USE master;
GO
DROP DATABASE qod_collation_db;
GO

DECLARE @var CHAR(1) = '¾'

SELECT @var
WHERE @var LIKE '%[0-9]%'