<div>
Alternately, this one works for me:<br />
<br />
SELECT<br />
&nbsp; OrderNumber,<br />
&nbsp; SUM(coalesce(OrderTotal,0)<wbr />)<br />
from<br />
&nbsp; deleteme<br />
GROUP BY<br />
&nbsp; OrderNumber<br />
;<br />
<br />
HTH, <br />
DaveSlash<br />

</div>


Alternately, this one works for me:

SELECT
  OrderNumber,
  SUM(coalesce(OrderTotal,0))
from
  deleteme
GROUP BY
  OrderNumber
;

HTH,
DaveSlash


<div>
<div class="content wysiwyg-content">
In my SUM query if the value is null I want it to return 0. &nbsp;How do I handle that for example,<br />
<br />
SELECT OrderNumber, SUM(OrderTotal) from tblOrders<br />
GROUP BY OrderNumber
</div>
</div>


In my SUM query if the value is null I want it to return 0.  How do I handle that for example,

SELECT OrderNumber, SUM(OrderTotal) from tblOrders
GROUP BY OrderNumber

Using ISNULL in SQL Query

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.