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:
in addition if data1 is empty, I want to suppress the entire field.
Anyone able to tell me how to do this?