[dba-SQLServer] Put humpty dumpty back together again

Wrap each potyential problem field in an  ISNULL()
It's the equivalent of the VBA NZ()



On 6 Jun 2008 at 10:20, jwcolby wrote:

> 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
> http://www.databaseadvisors.com
>