Can someone give me an example how to do this.
Select LocationName from CustomerLocation
Where CustId = 1
I am going to get multiple records I want to create a function that will give me back a comma string of Location Names as there could be 1 to Many records for a particular CustId. Also need to strip the last comma. So something like a varchar(500) I want to pass back with the return.