parsing a comma-delimited string in column?

[pandatime]

Hi,

I have a table with a column that can hold single values as well as a comma-delimited string, for exampe:

column
Joe, 1, Red
Mary
Ned, 2, Blue, Purple
Susan, 3

etc

How can I write something to grab a distinct result set of all the various values, which would be:

Joe
Mary
Ned
Susan
1
2
3
Red
Blue
Purple

Thanks much

 

[bborissov]

Check FAQ hare for function named dbo.Split

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.