During a recent training session a delegate asked "How do I concatenate fields that contain null values correctly?"
Solution
When creating SQL statements to concatenate fields, if one of the fields within the formula is NULL, the resulting calculated field will display a null value.
To resolve this issue, one must use the COALESCE function
The final formula will be:
COALESCE (Tablename.Fieldname_1, ' ') + ' ' + COALESCE (Tablename.Fieldname_2, ' ') + ' ' + COALESCE (Tablename.Fieldname_3, ' ')
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us
|