How to show "0" as default instead of "Null" in sql select query

Question

I want to get 0 instead of null in my select query.

I mean currently my query is showing NULL for amount column if there are no entry in table.

Can I get 0 for amount column in select query if it has NULL?

It depends on the query, but ISNULL will work most of the time. — CompanyDroneFromSector7G, Oct 19 '13 at 10:28

Rahul Tripathi · Accepted Answer · 2013-10-19T10:34:22.757

6

You can try like this:

select isnull(column,0)

Can I get 0 for amount column in select query if it has NULL?

Yes you can get. If you will show your exact table and column name then it would be the best else you can try like this:-

select isnull(amount,0) as Amount from MyTable

On a side note:-

You may also check out about ISNULL

edited Oct 19 '13 at 10:34

answered Oct 19 '13 at 10:23

Rahul Tripathi

score 1 · Answer 2 · answered Oct 19 '13 at 10:23

1

SELECT ISNULL(NULLCOLUMN1, 0) NULLCOLUMN1

answered Oct 19 '13 at 10:23

Gubi

2 Answers2