From: hforbric@yahoo.net   
      
   Jagdip Singh Ajimal wrote:   
   >   
   > 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   
      
   Consider this:  what is the definition of 'NULL' and how can anything   
   'equate' to that 'value'?   
      
   You want to use the 'IS NULL', not the '= NULL' construct.   
      
   (This is basic SQL - please consider reviewing your/an 'introduction to   
   SQL' documentation or book.  Things like this are not intuitive to the   
   uninitiated and will lead to frustration.)   
   /Hans   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)