title: Instead of NULL how do I show `0` in result with SELECT statement sql?
body: <p>I have one <code>stored procedure</code> which is giving me an output (I stored it in a #temp table) and that output I'm passing to another <code>scalar function</code>.</p>
  
  <blockquote>
    <p>Instead of NULL how do I show <code>0</code> in result with SELECT statement sql?</p>
  </blockquote>
  
  <p>For example stored proc is having select statement like follwing :</p>
  
  <pre><code>SELECT Ename , Eid , Eprice , Ecountry from Etable
  Where Ecountry = 'India'
  </code></pre>
  
  <p>Which is giving me output like</p>
  
  <pre><code>Ename    Eid    Eprice    Ecountry
  Ana      12     452       India
  Bin      33     NULL      India
  Cas      11     NULL      India
  </code></pre>
  
  <p>Now instead of showing <code>NULL</code> how can I show price as <code>0</code> ?</p>
  
  <p>What should be mention in <code>SELECT</code> statement to make <code>NULL</code> as <code>0</code> ?</p>