15e8f691   
   From: Plamen@SQLStudio.com   
      
   That means that some values are invalid dates. Try this:   
      
   SELECT CASE WHEN ISDATE(CAST(LDate  AS CHAR(8))) = 1   
                THEN CAST(CAST(LDate  AS CHAR(8)) AS DATETIME)   
           END   
   FROM dbo.Schedules;   
      
   --   
   Plamen Ratchev   
   http://www.SQLStudio.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)