Re: select only fields that don't contain null value

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 05/12/04 

Date: Thu, 13 May 2004 00:34:10 +0200

On Thu, 13 May 2004 03:19:11 +0530, Dinesh T.K wrote:

>Hugo,
>
>Isnt that the shortened version of:
>
>WHERE columnName1 is not null
> OR columnName2 is not null
> ....
> OR columnNameN is not null
>
>--
>Dinesh
>SQL Server MVP
>--

Hi Dinesh,

Yes, it is. I now see that Louis' post used AND, but I doubt if that
was what he meant. His description included "Losing rows that contain
*only* null columns". His suggestion with AND would lose all rows that
contain one or more null columns.

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)