Combining three fields into one

[dcutaia]

I need to combine three individual fields into one field.

Example:

Address3 = 30 characters
State= 2 characters
Zip code= 10 characters

What is the best way to combine these three fields into one field and take out the extra space.

Thanks,

DAC

[tomholden]

Re: Combining three fields into one

myfield = %Trimr(address3) + ' ' + state + ' ' + zip;