[AccessD] Put humpty dumpty back together again

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

2008/6/6 jwcolby <jwcolby at colbyconsulting.com>:

> 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 <http://www.colbyconsulting.com/>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com