I have 4 fields in My table Name, Addr1, Addr2, Addr3.
e.g.
Name: J Smith
Addr1 37 Main Street
Addr2 Auckland
Addr3 Null
I would like to combine these into one field that reads:-
J Smith, 37 Main Street, Auckland
Is there a way to do this with a case statement it function - I would like to select this table and list one field in the format above.
Start Free Trial
