Combine address fields into one field in SQL
Posted on 2008-06-11
I have 4 fields in My table Name, Addr1, Addr2, Addr3.
Name: J Smith
Addr1 37 Main Street
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.