[dba-SQLServer] Appending strings where there are nulls

jwcolby jwcolby at colbyconsulting.com
Wed Mar 19 18:11:46 CDT 2008


I am trying to build up a street address from a set of fields.  Any given
field may have a null.  If I just use + then anywhere there is a null in the
source I get a null as a result.  

What is the syntax to append fields to build an aliased field but avoid the
null issue?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 




More information about the dba-SQLServer mailing list