查找出db中不可见字符

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 ) + '%'
						 
         )