I would like to select all from a column and return it as string with '/' between the colors. How do I do that?
For example: MyTable(Id, Colors)
The column Colors has 'Brown','Blue','Green'
I would like to return: 'Brown/Blue/Green'
If there is only one color that is returned I would not like to show '/' (for example: 'Brown' but not 'Brown/')