• If I'm not mistaken, SELECT CAST(GETDATE() AS DATE) will only work on SS2008 and above, as the DATE type is new in 2008.

    *******************
    What I lack in youth, I make up for in immaturity!