SQL question

[Arc]

I'm using MySQL as a DB and i am trying to sum a field where the field isnt NULL

SELECT SUM(Quantity) FROM tblOrders WHERE Quantity NOT NULL

That ofcourse doesnt work...

What is the proper way to get rows from a DB with MySQL where a field Does not equal Null?

Thanks!😃

[altexis]

SELECT SUM(Quantity) FROM tblOrders WHERE Quantity IS NOT NULL

[Arc]

Yep that would be it...thanks!😃