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...