[dba-SQLServer] Appending strings where there are nulls

jwcolby jwcolby at colbyconsulting.com
Wed Mar 19 20:09:17 CDT 2008


>The Database From Hell, The SQL.

ROTFL.   


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 Arthur
Fuller
Sent: Wednesday, March 19, 2008 7:46 PM
To: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Appending strings where there are nulls

I sense another article coming on... The Database From Hell, The SQL. :) A.

On 3/19/08, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> 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.
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list