Declare @parameter varchar(400)
Declare @value varchar(400)
Declare @location int
Set @parameter = 'zhang;wu;guang;'
While(len(@parameter)> 0)
Begin
Select @location = charindex(';',@parameter)
--Print @location
Set @value = substring(@parameter,1,@location -1)
Print @value
Set @parameter = substring(@parameter,@location + 1,len(@parameter) - @location)
End