• AS previously stated:

    dunnjoe (5/5/2008)


    That's why I feel answer b is not correct. Answer b says the value is converted to an int. The error message says the conversion failed. So, it appears to be a compilation error.

    Unfortunately I came to the same conclusion ... the statement did NOT execute ... other than the error message

    Msg 245, Level 16, State 1, Line 1

    Conversion failed when converting the varchar value 'B' to data type int.

    There were NO values returned!!

    Still a good QOD just a bad wording of possible answers ... to the detriment of many of us

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]