Hi there I have separate adrress fields like Address, City, State and Zipcode but I would like to create a single address fields by combining all these four fields into one field like : 1345 Quail Creek Ln, Alexandria, VA 22039 Address City State Zipcode 1345 Quail Creek Ln Alexandria VA 22039 4569 Foxhole Drive Chantilly VA 22033 Single address field I want to create is: 1345 Quail Creek Ln, Alexandria, VA 22039 4569 Foxhole Drive, Chantilly, VA 22033 I tried using CATX function like this New_address = catx(',',Address,City,State,Zipcode); but it resolves into: 1345 Quail Creek LN,Alexandria,VA,22039 How do I insert space between two elements of the address separated by comma and just the space between state and ziocode as I have shown above ? Please help me. Thanks
... View more