提取字符串中的大写字母

DECLARE @s VARCHAR(MAX)
SET @s=''
;
WITH cte AS (
    SELECT 'Abc-Def' AS ch
)
SELECT @s=@s+SUBSTRING(ch, sv.number, 1)
FROM   cte
       CROSS APPLY [master].dbo.spt_values AS sv
WHERE  sv.type = 'P'
       AND sv.number BETWEEN 1 AND LEN(ch)
       AND ASCII(SUBSTRING(ch, sv.number, 1)) NOT BETWEEN ASCII('a') AND ASCII('z')

SELECT @s AS r
/*
r
A-D 
*/