In the update string list, the string at the specified position

String
if exists (SELECT * from dbo.sysobjects WHERE id = object_id (N ' [dbo].[ F_UPDATESTR] ' and xtype in (n ' FN ', n ' IF ', n ' TF ')) drop function [dbo]. [F_updatestr] Go

/*--the string for the specified position in the list of update strings

Update string list, the string at the specified position is a new value if the position is out of range, do not update

--Jiangjian 2004.07--*/

/*--Call Example

Select Dbo.f_updatestr (' 001|002|003| ', 1, ' 00a ', ' | ') --*/create function F_updatestr (@s varchar (8000), @pos int, @newstr varchar (MB), @spliststr varchar (10)--delimiter for List of strings) Returns varchar (8000) Asbegin declare @i int, @ilen int

Select @i=charindex (@spliststr, @spliststr +@s), @ilen =len (@spliststr) while @i>0 and @pos >1 select @i=charindex (@ spliststr,@s,@i) + @ilen, @pos = @pos-1 return (case @i when 0 then @s else stuff (@s,@i,charindex (@spliststr, @s+ @spliststr, @ i)-@i, @newstr) End Endgo