DarkHound
asked on
Concat fields separated by commas
I have a database with several fields I need to combine, separated by commas. The problem is some of these fields will be null and I don't want to run into the issue where I see the following:
data1, data2, , ,
I want it to display as:
data1, data2
in addition if data1 is empty, I want to suppress the entire field.
Anyone able to tell me how to do this?
data1, data2, , ,
I want it to display as:
data1, data2
in addition if data1 is empty, I want to suppress the entire field.
Anyone able to tell me how to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nevermind, I figured it out. Thanks!
ASKER