用parsename函数来截取字符串

 -----只适合有4个部分（3个分号）的情况

if object_id('f_str')is not null drop function f_str
go
create function f_str(@s varchar(50),@name int)
returns varchar(30)
as
begin
    set @s=replace(@s,';','.')
    set @s=case @name when 4 then replace(@s,'.'+parsename(@s,1),'')
                      when 3 then replace(@s,parsename(@s,2)+'.','')
                      when 2 then replace(@s,parsename(@s,3)+'.','')
                      when 1 then replace(@s,parsename(@s,4)+'.' ,'')   
            end
    return replace(@s,'.',';')
end

go
-------------------------------------------
select s=dbo.f_str('a;b1;c23;d34',1)

b1;c23;d34

(1 行受影响)
-------------------------------------------
select s=dbo.f_str('a;b1;c23;d34',2)

a;c23;d34

(1 行受影响)


-------------------------------------------
select s=dbo.f_str('a;b1;c23;d34',3)

a;b1;d34

(1 行受影响)
-------------------------------------------
select s=dbo.f_str('a;b1;c23;d34',4)


a;b1;c23

(1 行受影响)