Dear Sir: The Version of Mysql is mysql-3.23.38. The OS is Win NT SP 5. I have a problem with below SQL Statement "Select Sum(Cost) as TotalCost from Item" All the entries for Cost Field has the Value Null. The result of this Query is TotalCost = 0. But is not it suppose to be Null instead of 0. Because when i try "Select Avg(Cost) as TotalCost from Item" OR "Select Max(Cost) as TotalCost from Item" The result of this Average Query is TotalCost = Null. Regards Jack Chan --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php