ac4c09b2   
   From: Plamen@SQLStudio.com   
      
   If this is YYYYMMDD, then it is very simple, just cast to character format and   
   then to date:   
      
   SELECT CAST(CAST(20010101 AS CHAR(8)) AS DATETIME)   
      
   You can delete like:   
      
   DELETE FROM Foo   
   WHERE date < '20051231';   
      
   --   
   Plamen Ratchev   
   http://www.SQLStudio.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)