T-SQL Function to return a string of concantenated values
Posted on 2006-05-02
Here's the deal...
I need a function that will return a string. The string needs to be created on the fly when I pass it an ITEM_ID.
Say I have a table called COLORS:
Users may add none, one, or many colors to an item. For example, an item may be Red and Green. The user adds Red an then adds Green. so there are two records created in my ITEM_COLORS table.
What I need is a function to return me the colors of ITEM as a string (Red, Green).