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

"Doug Ly" <deadlock@dev.null> wrote in message
news:pMqoc.26579$E27.5138@newssvr22.news.prodigy.c om...[color=blue]
> 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
>[/color]
This is a DB2 forum.

But you might try adding a where clause, such as:

where col_name not null

"Doug Ly" <deadlock@dev.null> wrote in message
news:pMqoc.26579$E27.5138@newssvr22.news.prodigy.c om...[color=blue]
> 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
>[/color]
This is a DB2 forum.

But you might try adding a where clause, such as:

where col_name not null

Doug Ly wrote:
[color=blue]
> 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[/color]

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! =-----

Have you tried "select sum(coalesce(column,0)) ...."? It won't affect
your sum to add zero.

Ian <ianbjor@mobileaudio.com> wrote in message news:<40a2755e$1_1@corp.newsgroups.com>...[color=blue]
> Doug Ly wrote:
>[color=green]
> > 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[/color]
>
> 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! =-----[/color]