Carlo Romagnano (10/18/2009)

---

Simply add DISTINCT clause.

create table fruit(name...

Jeff Moden (10/18/2009)

---

And here's a function for items that don't exceed 8K...

--===== Create a function that uses VARCHAR(8000) with a DUPE Eliminator

CREATE FUNCTION dbo.Concat8KTestDupElim

...

Yours is pretty cool, but what do I need to modify if I want to get rid of duplicates? 🙂