Written by:Tomasz Modelski
2008-08-08 20:01:24Z

I needed T-SQL split function and found on : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=543217&SiteID=1
by Jens Suessmeyer :

CREATE FUNCTION dbo.Split
(
    @String VARCHAR(200),
    @Delimiter VARCHAR(5)
)
RETURNS @SplittedValues TABLE
(
    OccurenceId SMALLINT IDENTITY(1,1),
    SplitValue VARCHAR(200)
)
AS
BEGIN
    DECLARE @SplitLength INT
    WHILE LEN(@String) > 0
    BEGIN
        SELECT @SplitLength = (CASE CHARINDEX(@Delimiter,@String) WHEN 0 THEN
            LEN(@String) ELSE CHARINDEX(@Delimiter,@String) -1 END)
       
        INSERT INTO @SplittedValues
            SELECT SUBSTRING(@String,1,@SplitLength)
       
        SELECT @String = (CASE (LEN(@String) - @SplitLength) WHEN 0 THEN ''
            ELSE RIGHT(@String, LEN(@String) - @SplitLength - 1) END)
    END
    RETURN
END

TrackbackPrint

Location: BlogsTomasz Modelski IT blog

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel