R
Ricter
I would like to concatenate a series of fields, say Att1, Att2, Att3, and Att4.
I would like a comma and a space between each one.
If Att2, Att3, or Att4 is/are null, I do not want a comma and space added.
With the exception of Att1, any subsequent field may or may not be null.
What I'm after is: "Att1, Att2, Att4"
and not: "Att1, Att2, , Att4"
Is there an example of this kind of funcitonality somewhere that I can look
at, or can someone give me a code snippet that I could expand for more
attributes?
Thanks.
I would like a comma and a space between each one.
If Att2, Att3, or Att4 is/are null, I do not want a comma and space added.
With the exception of Att1, any subsequent field may or may not be null.
What I'm after is: "Att1, Att2, Att4"
and not: "Att1, Att2, , Att4"
Is there an example of this kind of funcitonality somewhere that I can look
at, or can someone give me a code snippet that I could expand for more
attributes?
Thanks.