Doug Ly wrote:
Hi,
I use WinSQL to execute a query. It takes the sum of a column. Within the
column, there are several NULL values and winSQL complains that it cannot
add NULL values.
Does anybody have an idea how to get it work? Thanks
SELECT SUM(column) ...
SUM(), as documented in the SQL Reference, ignores NULL values in the column.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----