sbornstein2
asked on
SQL Query Function Syntax Help
Hello all,
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.
Thanks all
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.
Thanks all
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER