09d9c4d6   
   From: Plamen@SQLStudio.com   
      
   The best would be to use a half-open interval:   
      
   SELECT    
   FROM Foo   
   WHERE datecol >= DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP) - 3, 0)   
      AND datecol <  DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP), 0);   
      
   --   
   Plamen Ratchev   
   http://www.SQLStudio.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)