jwcolby
jwcolby at colbyconsulting.com
Wed Mar 19 18:30:12 CDT 2008
LOL, the OhNoSecond strikes again. One answer is ISNULL(Value,'ReplacementValue'). Now whether this will work for a million records in near real time is another question. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Wednesday, March 19, 2008 7:12 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Appending strings where there are nulls 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