refs
https://stackoverflow.com/questions/8655909/whats-the-best-way-to-identify-hidden-characters-in-the-result-of-a-query-in-sq
原理先生成一个不可见字符表,而后用表关联后以不可见字符为关键字,查询表。
--SELECT * from by_dtu WHERE DATALENGTH(bianhao) > LEN(bianhao)
;WITH cte AS
(
SELECT 1 AS CharCode
UNION ALL
SELECT CharCode + 1 FROM cte WHERE CharCode <47 and CharCode!=37
)
SELECT * FROM by_dtu T cross join cte
WHERE
EXISTS (SELECT *
FROM by_dtu Tx
WHERE Tx.id = T.id
AND
-- 过滤掉% 因为它是个通配符
-- Tx.bianhao LIKE '%' + CHAR(cte.CharCode) + '%'
Tx.bianhao LIKE '%' + (select case when cte.CharCode=37 then '\'+CHAR(cte.CharCode) else CHAR(cte.CharCode) end ) + '%'
)