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

Try these three alternatives:

1. ISNULL(MyColumn, 0)

2. SELECT CASE WHEN MyColumn IS NULL THEN 0 ELSE MyColumn END FROM MyTable

3. SELECT COALESCE(MyCoumn, 0) FROM MyTable

There is another way but it is not supported by most of the databases SELECT MyColumn + 0 This might work, but NULL + anything is still NULL in T-SQL.

Use coalesce():

select  coalesce(Eprice, 0) as Eprice

In SQL Server only, you can save two characters with isnull():

select  isnull(Eprice, 0) as Eprice

Try ISNULL(Eprice, 0) instead of Eprice