SQL custom Functions, separators

--------------establishing a stored procedure

CREATE function [dbo]. [Split]

(

@str varchar (4500),

@sep varchar (1)

)

Returns @t table (id int identity (), Col varchar (4500))

As

Begin

--Defines the current position, delimiter start and string length, and the currently acquired string

declare @posi int, @start int, @str_leg int, @gchar varchar (2), @mingzhong int

Set @str_leg =len (@str)

Set @posi =0

Set @start =0

Set @mingzhong =0

while (@posi <[email Protected]_leg)

Begin

Set @gchar =substring (@str, @posi, 1)

if (@[email protected])

Begin

INSERT into @t values (substring (@str, @start +1,@[email protected])

Set @[email protected]

End

Set @[email protected]+1

End

Return

End

------------execution to: query results for delimiters

SELECT * from Dbo.split (' 234;32423;; 2342;a;b;234234;23, ', '; ')

SQL custom Functions, separators