Is there a way to use SQL to concatenate multiple string fields that may contain null values? The methods I've been able to come up with only work without nulls. See attached map file for examples and test data. Thanks.

Attachments:
T.map

SELECT Coalesce([field 1], '') + Coalesce([field 2], '') FROM [T]

http://www.mppng.nl/manifold/pointlabeler

Many thanks Chris. Have an excellent evening :-)