SQL 模拟C# Trim(',') 并且增加新功能

create function MyTrim(@str varchar(3000),@c varchar(100),@isfirst int) 
returns varchar(3000)
as
begin
declare @strlast varchar(max)
if(@isfirst=1)
  begin
    select @strlast=stuff(@str,1,1,@c) 
  end
else if(@isfirst=0)
  begin
 select @strlast=stuff(@str,len(@str),1,@c)
  end
else
  begin
 select @strlast=stuff(stuff(@str,len(@str),1,@c),1,1,@c)
  end
 return @strlast;
end  

select dbo.MyTrim('aaaa,','',0)

select dbo.MyTrim(',aaaa,','',1)

select dbo.MyTrim(',aaaa,','',2)

0,替换末尾字符，1，替换首字符 2，替换首尾字符