I am trying to populate an Address column with a Member's full address.
The database that I am using stores Address1, Address2 (Such as an APT# or Suite#), City, State, and ZIP in separate columns as it should.
I have coded as follows:
[Member Address] = RTRIM(v.Address1) + ' ' + RTRIM(v.Address2) + ' ' + RTRIM(v.City) + ' ' + v.State + ' ' + v.ZIP,
If the Member does not have any data in Address2, it is inserting a blank to go a long with the blank space that I have already inserted to keep Address1 and Address2 spaced correctly.
Essentially, my code is working if the Member has data in both Address1 and Address2 only.
1 Main Street Apt#1 Anytown, MA 12654
2 South Street Sometown, MA 16545 (Displaying two spaces between Street and Sometown)
Does anyone have any ideas?