sqlserver字符串中只挑选出数字

sqlserver字符串中只挑选出数字

DECLARE

@S VARCHAR(500)='B0002'

BEGIN

WHILE PATINDEX('%[^0-9]%', @S) > 0

BEGIN

SET @S = STUFF(@S, PATINDEX('%[^0-9]%', @S), 1, '');

END

END

SELECT * FROM dbo.HT_合同档案资料 ht WITH(NOLOCK) WHERE ht.店铺代码=@S

----------------------------------------------------------------------------------------------------------------------------------------

SELECT * FROM dbo.LC_LOCATION lc WITH(NOLOCK) WHERE STUFF(lc.LC_CODE, PATINDEX('%[^0-9]%', lc.LC_CODE), 1, '')='2160'