RE: sum() Function and NULL values

Thanks for all your responses. I went with the coalesce way - it works like a charm. Thanks again! Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 480-1870 Mobile/Emergencies (516) 908-4185 Fax http://www.meitech.com/ -- MySQL General Mailing List F

RE: sum() Function and NULL values

"Jay Blanchard" <[EMAIL PROTECTED]> wrote on 12/16/2004 01:00:00 PM: > [snip] > Is there any way to make sum() return "0" instead of "NULL" when one or > more of the rows being sum()'d is null? > > Phrased another way, is there a way to make mySQL treat "NULL" as "0" > when dealing with mathemat

Re: sum() Function and NULL values

>Is there any way to make sum() return "0" instead of "NULL" when one or >more of the rows being sum()'d is null? > >Phrased another way, is there a way to make mySQL treat "NULL" as "0" >when dealing with mathematical functions? You can use ifnull select sum(ifnull(points,0)) from abc;

RE: sum() Function and NULL values

[snip] Is there any way to make sum() return "0" instead of "NULL" when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make mySQL treat "NULL" as "0" when dealing with mathematical functions? [/snip] Use an IF... SELECT SUM(IF(myColumn IS NULL, 0, myColumn)

Re: sum() Function and NULL values

Hi Tim, I guess you can add something like this to your statement: SELECT COALESCE( SUM(column) , 0 ) FROM ... /Johan Gustafson, Tim wrote: Is there any way to make sum() return "0" instead of "NULL" when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make myS

sum() Function and NULL values

Is there any way to make sum() return "0" instead of "NULL" when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make mySQL treat "NULL" as "0" when dealing with mathematical functions? Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-