[dba-SQLServer] Put humpty dumpty back together again

Try the ISNULL function

At 12:00 PM 6/6/2008, you wrote:
>Date: Fri, 06 Jun 2008 10:20:06 -0400
>From: jwcolby <jwcolby at colbyconsulting.com>
>Subject: [dba-SQLServer] Put humpty dumpty back together again
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>,         Dba-Sqlserver
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID: <48494796.2060006 at colbyconsulting.com>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>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
>
>
>------------------------------
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>
>
>End of dba-SQLServer Digest, Vol 64, Issue 5
>********************************************