sbornstein2
asked on
SQL Server query concat question
Hello all,
If I have 4 fields that are CustomerGroup1, CustomerGroup2, CustomerGroup3, CustomerGroup4. I want to concat one string with a comma separator. How do I do this so I don't have an extra comma at the end if for example 3 and 4 is null.
If I have 4 fields that are CustomerGroup1, CustomerGroup2, CustomerGroup3, CustomerGroup4. I want to concat one string with a comma separator. How do I do this so I don't have an extra comma at the end if for example 3 and 4 is null.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks I needed all 4 fields to be checking for null.
Open in new window