OK - I'm being dense. How is that query specific to MS SQL 2005? Outside of the varchar(max) option? -----Original message----- From: "jason.handby" jason.handby at corestar.co.uk Date: Wed, 28 Feb 2007 01:55:50 -0800 To: thelist at lists.evolt.org Subject: Re: [thelist] mssql split (You out there Rudy?) > > Recursion is your friend. > > > > I found this, Rudy will bless it or curse it & show you a > > better way. ;-) > > > > http://codeinet.blogspot.com/2006/08/split-string-using-recurs > ive-sql.html > > > > It's a nice solution, but isn't it written for SQL Server 2005? Brian's > using 2000.