Arthur Fuller
fuller.artful at gmail.com
Fri Jun 6 15:36:33 CDT 2008
It's a little more complicated than that. In your formula you'll end up with three consectie spaces if two fields are null. Arthur On Fri, Jun 6, 2008 at 11:30 AM, Paul Hartland <paul.hartland at googlemail.com> wrote: > Off the top of my head try: > > Select ISNULL(HouseNumberPrefix,'') + ' ' + ISNULL(HouseNumber,'') + ' ' + > ISNULL(HouseNumberSuffix,'') + ' ' + ISNULL(Direction,'') + ' ' + > ISNULL(StreetName,'') + ' ' + ISNULL(Mode,'') + ' ' + ISNULL(Quadrant,'') + > ' ' + ISNULL(Appt#,'') > > Paul Hartland >