Re: How to test for a null value in a date column

"e.DateFinished = NULL" - did you try "e.DateFinished is null"

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Jagdip Singh Ajimal" <jsa1981_at_hotmail.com> wrote in message news:c84eb1b0.0402120435.217730f4_at_posting.google.com...
> I am creating the following view
>
> CREATE OR REPLACE VIEW AllMedics AS
> SELECT * FROM Medic m, Employee e
> WHERE e.EmployeeID = m.MedicID AND
> e.DateFinished = NULL;
>
> But all I get is "no rows selected". How do I test a date column to
> see if it is null?
>
> NB The DateDinished above means the date that the employee was
> fired/resigned.
>
> Any help would be greatly appriciated.
>
> Jagdip Singh Ajimal
Received on Thu Feb 12 2004 - 18:28:50 CET