IF OBJECT_ID('FUN_MU_REPLACENUM') IS NOT NULL DROP FUNCTION FUN_MU_REPLACENUM
GO
CREATE FUNCTION FUN_MU_REPLACENUM(
@STR VARCHAR(8000)
)
RETURNS VARCHAR(8000)
AS
--DECLARE @STR VARCHAR(100)
--SELECT @STR='asd[num]qwe23'
BEGIN
WHILE @STR LIKE '%[0-9]%'
BEGIN
SELECT @STR=STUFF(@STR,PATINDEX('%[0-9]%',@STR),PATINDEX('%[^0-9]%',STUFF(@STR+' ',1,PATINDEX('%[0-9]%',@STR+' ')-1,''))-1,'[num]')
END
RETURN @STR
END
GO
SELECT DBO.FUN_MU_REPLACENUM('asd12345qwe23')