declare @temp1 char(4)
declare @temp2 char(2)
declare @tempsum varchar(255)
select @temp1 = 'abcd'
select @temp2 = 'cd'
select replace(@temp1, @temp2, '')ab(1 row(s) affected)
declare @temp2 char(2)
declare @tempsum varchar(255)
select @temp1 = 'abcd'
select @temp2 = 'cd'
select replace(@temp1, @temp2, '')ab(1 row(s) affected)
declare @temp2 nvarchar(2)
declare @tempsum nvarchar(255)
select @temp1 = 'abcd'
select @temp2 = 'cd'
select @tempsum = @temp1 + @temp2 select replace(@temp1,@temp2,'')