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