Ron Weiner pretended :
Opps mised the "and" Here is a Revision:
SELECT [FName] & IIf(Len(nz([Spouse],''))>0, ' and ' & [Spouse],'') & '
' & [Lname] AS TheConcatenatedName
Ed and Debbie Pringle where the spouse is defined
Ed Pringle where ther was no spouse