• Just a question: Why would one want to pass a DATE to ISDATE()? Surely that should always return TRUE, even if it is NULL (which it doesn't if passed a NULL datetime or varchar)?

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]