exclude null values

[newtosql]

Im new to sql and Id like to exclude null values from my query. When I run my query (in query analyzer) I still see the null values that I want to exclude.

select col_a
from tabl_a (nolock)
where (NOT (col_b IS NULL))

Any ideas? Thanks guys.

 

[laradegroot]

I'm not quite sure why you would want to use the "nolock" statement this way, but the code

select col_a
from table (nolock)
where col_b is not null

should work (also without "(nolock)")

Good luck!

Lara

 

[jonwolds]

Hi,

Try the following:

SELECT
col_a
FROM
Table_a
WHERE
col_b IS NOT NULL

 

[newtosql]

Hmm, that doesnt work. Im still seeing NULLs in my results set in query analyzer. Its a datetime column.

Is there anything else I should be trying?

 

[newtosql]

by the way...when I use this query in a View, my query doesnt return any null values (which is what I want). So why doesnt this work in query analyzer?

 

[dbomrrsm]

This might sound a bit stupid but are you seeing nulls in the selected column a ?

If so the query may well return null values in column a as your where clause is where column b is null not column a.

[blue]DBomrrsm[/blue]