I am printing a large number of labels with the following format:
[salutation] [first] [init] [last] [suffix] * suffix example: Jr.,Sr.III
[city] [state] [zip]
The main problem is line 1. [salutation], [suffix] and Middle name (init) may be a NULL value. I need the proper Trim() procedure.
E.G. if NOT ISNULL (init) then [first] & " " & [init] & " " & [last] else [first] & " " & [last]. Any help will be appreciated.