把名字按字拆分,然后判断是否存在重复

CREATE TABLE #T
(
    名字 VARCHAR(10)
)
 
INSERT INTO #T VALUES('汤晶1晶'),('张三丰'),('欧阳兰兰'),('孙悟空')
 
--把名字按字拆分,然后判断是否存在重复
SELECT * FROM #T WHERE EXISTS
(  
    SELECT * FROM
    (
    SELECT SUBSTRING(名字,number,1) AS V
        FROM master..spt_values WHERE type='P' AND number BETWEEN 1 AND LEN(名字)
    ) A
    GROUP BY V HAVING COUNT(1)>1
  )

 
drop  table #T