Question: I have one `stored procedure` which is giving me an output (I stored it in a #temp table) and that output I'm passing to another `scalar function`.

> 
> Instead of NULL how do I show `0` in result with SELECT statement sql?
> 
> 
> 

For example stored proc is having select statement like follwing :

```
SELECT Ename , Eid , Eprice , Ecountry from Etable
Where Ecountry = 'India'

```

Which is giving me output like

```
Ename    Eid    Eprice    Ecountry
Ana      12     452       India
Bin      33     NULL      India
Cas      11     NULL      India

```

Now instead of showing `NULL` how can I show price as `0` ?

What should be mention in `SELECT` statement to make `NULL` as `0` ?

Answer: 
Try `ISNULL(Eprice, 0)` instead of `Eprice`
CASE WHEN price IS NULL THEN 0 ELSE price END