[dba-SQLServer] Put humpty dumpty back together again

jwcolby jwcolby at colbyconsulting.com
Fri Jun 6 09:20:06 CDT 2008


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



More information about the dba-SQLServer mailing list