Thanks for that. When I said single string, I meant that I wanted the results to be returned as one line (or one row), for example:

Annual Giving 2008, Annual Giving...

My function is below:

USE [SAS_LIVE]

GO

/****** Object: UserDefinedFunction [dbo].[fn_SplitString] Script Date: 01/17/2011 08:54:11 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:<Partridge, Mike>

-- Create date: <14th January 2011>

-- Description:<Split...