|During a recent training session a delegate asked "How do I concatenate fields that contain null values correctly?"|
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