title: How Can we use ISNULL to all Column Names in SQL Server 2008?
body: <p>I have a question </p>
  
  <p>I tried to <code>google</code> it but looks like they don't like <code>*</code> </p>
  
  <p>I'm using SQL Server 2008.</p>
  
  <p>I have the following database table: </p>
  
  <pre><code> P_Id   ProductName UnitPrice   UnitsInStock    UnitsOnOrder
  ------------------------------------------------------------------------
     1    Jarlsberg   10.45                 16    15
     2    Mascarpone  Null                  23    NULL 
     3    Gorgonzola  15.67                  9    20
  </code></pre>
  
  <p>If I need to replace the <code>null</code> with a string I know I do :</p>
  
  <pre><code> SELECT ISNULL(UnitsOnOrder,'No Data') FROM tbl
  </code></pre>
  
  <p><strong>Questions</strong> </p>
  
  <ul>
  <li>How can I use <code>ISNULL()</code> with multi column names ?</li>
  <li>is it possible to use it with <code>*</code> </li>
  </ul>
  
  <p><em>Like</em></p>
  
  <pre><code>SELECT ISNULL(* , 'NO data') FROM tbl 
  </code></pre>
  
  <p>I think this will be tricky because of the datatype, you can't pass string to <code>INT</code> datatype  so how can I fix this too </p>
  
  <p><strong>Update</strong> </p>
  
  <p>Okay if i use <code>ISNULL(</code>) with a datatype of <code>int</code> it will return <code>0</code> 
  which will be a value to me , how can i pass empty string instead ? </p>