• Michael Valentine Jones (9/30/2011)


    No it wouldn't. You could have tested that before you posted. 😉

    Yep, or I should've just read the query properly! Didn't see the part of the case statement where you used the ISDATE function on the formatted date. Sorry 🙂


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/