sql截取特殊字符分隔开的字串

--@BadStr的值为：管理员|我是管理员|江泽民|胡锦涛|邓小平|毛泽东|超级管理员|客服|客服人员
--通过以下循环，取到每个字串
declare @BadStr varchar(500),@sunStr varchar(50),@bBad int,@index int
select @BadStr=BadUserName from web_config
set @index = CHARINDEX('|',@BadStr)
declare @i int
set @i = 0
while(@i = 0)
begin 
if @index = 0 --取得最后一个字串
begin
set @sunStr = @BadStr
set @i = 1
end
if @index > 0
begin
set @sunStr = SUBSTRING(@BadStr,0,@index)
select @BadStr = right(@BadStr,len(@BadStr)-charindex('|',@BadStr))
set @index = CHARINDEX('|',@BadStr)
end
select @sunStr
end