• Hi,

    Before answering the question i reffered the below mentioned blog and got it correct.

    http://blog.sqlauthority.com/2011/09/07/sql-server-denali-conversion-function-try_parse-a-quick-introduction/

    Eventhough u get error message for Parse(), first two rows will be converted to datetime and u can see that in results.

    This is the basic functionality of CAST and CONVERT too..

    --
    Dineshbabu
    Desire to learn new things..