declare @name nvarchar(1000)
set @name='南京路123弄456号789室'
declare @i int
set @i=1
while @i<=9
begin
select @name=REPLACE(@name,CAST (@i as CHAR(1)),'*')
set @i=@i+1
end
select @name
set @name='南京路123弄456号789室'
declare @i int
set @i=1
while @i<=9
begin
select @name=REPLACE(@name,CAST (@i as CHAR(1)),'*')
set @i=@i+1
end
select @name
declare @s varchar(100)
set @s = '南京路123弄456号789室'
select replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(@s,'1','*'),'2','*'),'3','*'),'4','*'),'5','*'),'6','*'),'7','*'),'8','*'),'9','*'),'0','*')