CREATE PROCEDURE [mytab_pro]
@char varchar(50)
AS
declare @text varchar(50),@textlength int,@zhi int,@w int,@c int,@cl int,@cl2 int
select @text=text from mytab where id=1
select @textlength=datalength(@text)
select @c=datalength(@char)
select @w=patindex('%'+@char+'%',@text)
print convert(varchar(50),@w)
if convert(varchar(50),@w)>0
begin
select @zhi=@w+@c-1+3
print @zhi
select right(left(@text,@zhi),1)
select right(@text,@textlength-@zhi+1) as '值'
select @cl=patindex('%,%',right(@text,@textlength-@zhi+1))
select @cl2=patindex('%}%',right(@text,@textlength-@zhi+1))
print @cl
print @cl2
if @cl!=''
select left(right(@text,@textlength-@zhi+1),@cl-1)
/*select right(left(@text,@zhi),@cl-1) as '值'*/
else if @cl2!=''
select left(right(@text,@textlength-@zhi+1),@cl2-1) as '值3'
end
GO
温馨提示:答案为网友推荐,仅供参考