Sql Splitting Function

Question

I have a string like that "10*cat*123456;12*rat*789;15*horse*365" i want to split it to be like that "cat, rat, horse" I have made this Function

CREATE FUNCTION [dbo].[Split](@BenNames VARCHAR(2000))
RETURNS VARCHAR(2000)
AS
BEGIN
    DECLARE @tmp VARCHAR(2000)
    SET @tmp = @BenNames    
    SET @tmp = SUBSTRING(
            SUBSTRING(@tmp, CHARINDEX('*', @tmp) + 1, LEN(@tmp)),
            0,
            CHARINDEX('*', SUBSTRING(@tmp, CHARINDEX('*', @tmp) + 1, LEN(@tmp)))
        )
    RETURN @tmp    but it only split only one part "10*cat*123456"

i want to send every part to this by another function or another looop

pb. · Accepted Answer · 2010-01-21 12:40:11Z

1

Have you taken a look at: http://blogs.microsoft.co.il/blogs/itai/archive/2009/02/01/t-sql-split-function.aspx

answered Jan 21, 2010 at 12:40

pb.

4612 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

RMohammed Over a year ago

sorry all, I didn't give myself time to understand the idea thank you "pb"

Collectives™ on Stack Overflow

Sql Splitting Function

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related