RE: IS NULL not working in WHERE clause.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Earl (Earl_at_discussions.microsoft.com)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 14:25:03 -0800

The query does return rows where the time_id is NULL and where the time_id
has an integer value (surrogate key). You can see a subset of the rows
returned in the reply I sent to David Portas.

"Brandon Lilly" wrote:

> Does this query return any values where the time_id column contains NULL:
>
> select bus_date, time_ordered, time_id
> from [vicorp\gillic].pmix_fact1
> where bus_date = '2003-11-01'
> and time_ordered between '2003-10-31 00:05:54' and '2003-11-05 13:38:11'
> order by time_ordered
>
>
> Brandon