Arthur Fuller
fuller.artful at gmail.com
Wed Mar 19 18:31:46 CDT 2008
+ Isnull({mycolumn},'')
A.
On 3/19/08, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>