Answers for "from sql select the values with comma separated using coalesce"

coalesce for comma separated in sql server

DECLARE @List VARCHAR(8000)

SELECT @List = COALESCE(@List + ',', '') + CAST(OfferID AS VARCHAR)
FROM   Emp
WHERE  EmpID = 23

SELECT @List

Posted by: Guest on May-04-2020

Code answers related to "from sql select the values with comma separated using coalesce"