22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @A VARCHAR(29)
DECLARE @B VARCHAR(29)
SET @A='01000 00000 00000 00000 00000'
SET @B='01000 00000 00000 00000 00000'
SELECT *
FROM (SELECT SUBSTRING(REPLACE(@A,' ',''),NUMBER,1) AS SINGLE_CHAR,NUMBER
FROM MASTER.DBO.SPT_VALUES
WHERE TYPE='P' AND NUMBER>=1 AND NUMBER<=LEN(REPLACE(@A,' ',''))) AS A
JOIN
(SELECT SUBSTRING(REPLACE(@B,' ',''),NUMBER,1) AS SINGLE_CHAR,NUMBER
FROM MASTER.DBO.SPT_VALUES
WHERE TYPE='P' AND NUMBER>=1 AND NUMBER<=LEN(REPLACE(@B,' ',''))) AS B ON A.NUMBER=B.NUMBER AND A.SINGLE_CHAR=1 AND B.SINGLE_CHAR=1