On Thursday, October 11, 2012 11:40:32 AM UTC+1, Bob Barrows wrote:   
   > Look up the Style arguments for CONVERT() in BOL. This can all be   
   > avoided by using explicit conversions.   
      
   CAST may be preferred instead of CONVERT, since it's ANSI standard   
   and portable between different SQL DBMS - if that's a consideration.   
   CONVERT has more options, particularly for style and localisation,   
   such as for date/time.   
      
      
   evidently refers to SQL Server 2000, but it makes the case for CAST.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)