• Yes. 2 should have been an option. I would have gotten it wrong then instead of testing it to get it right.

    Nice QoD. We are destined to constantly forget the simplest of things.

    And...

    select @date, convert(varchar(20), @date)

    is the same as

    select @date, convert(varchar(20), @date, 0)

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers