[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.
>