• CAST will accomplish what you are looking for.

    select cast(cast('Jul 24 2013 8:05AM' as date) as datetime)

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]