[AccessD] Put humpty dumpty back together again

I have a database that has split the address line into

HouseNumberPrefix
HouseNumber
HouseNumberSuffix
Direction
StreetName
Mode (N, NW etc)
Quadrant
Appt#

I need to put Humpty back together again to feed off to 
Address Validation.  How would I do that in SQL?

I THINK I can just append them all together with spaces 
between the parts and that would be fine EXCEPT that when 
you do something like NULL + SomeString you end up with null.

How would I do what I am trying to do in SQL?

-- 
John W. Colby
www.ColbyConsulting.com