Sql 分割 键值对字符串 得到某值对应的名称

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER function [dbo].[GetStrOfIndex]
(
@content varchar(1024), --要分割的字符串
@index varchar(500) --要获取的元素的值
)
returns varchar(1024)
as
begin
declare @str varchar(500)
if(charindex(@index,@content)<>0)
	begin
		declare @strname varchar(500)
		set @strname=substring(@content,charindex(@index,@content),len(@content)-charindex(@index,@content)+1)
		if(charindex(',',@strname)<>0)
			set @str= substring(@strname,charindex(':',@strname)+1,charindex(',',@strname)-charindex(':',@strname)-1)
		else
			set @str= substring(@strname,charindex(':',@strname)+1,len(@strname)-charindex(':',@strname))
	end
else
	set @str= @index
	return @str
end

示例如下：

select dbo.GetStrOfIndex('1:普通员工,3:部门经理,6:常务副总,7:总经理,8:董事长','3')

返回值：

部门经理

转载于:https://www.cnblogs.com/rsls/archive/2013/05/15/4364103.html