• Thanks everyone, this has been really useful!

    I have used the function to return all strings in the set after the nth string using a little feature for concatenating strings I found on this site...

    eg:

    DECLARE @strReturn VARCHAR(8000)

    SELECT @strReturn = COALESCE(@strReturn,'')+String+' '

    FROM dbo.fnSetSplitSV('The Quick Brown Fox Jumped Over the Slow Lazy Dog',' ')

    WHERE Row >= 8

    SELECT @strReturn

    this will return 'Slow Lazy Dog'

    Cheers

    David

     

    If it ain't broke, don't fix it...