Re: [SQL] query using a date field that isn't set

On Tue, 02 Nov 2004 10:44:41 -0500 "John B. Scalia" <[EMAIL PROTECTED]> wrote: > I've got a SQL problem that's stumping me. I have an employee table > with a field labeled: > > Emp_terminatedDATE > > Obviously, some employees in this table won't have this field set. I > want a query t

[SQL] query using a date field that isn't set

Hi all,   I’ve got a SQL problem that’s stumping me. I have an employee table with a field labeled:   Emp_terminated    DATE   Obviously, some employees in this table won’t have this field set. I want a query to select only employees without this field being set, ie., only cur