• I just tried it with 2008R2 and, as expected, got 2 error messages.

    Msg 195, Level 15, State 10, Line 12

    'TRY_PARSE' is not a recognized built-in function name.

    Msg 195, Level 15, State 10, Line 15

    'PARSE' is not a recognized built-in function name.

    Unfortunately, I can't remember what my 5th answer was, as only 4 apply! I think I misread an answer about NULL values.

    1. Select #1 does NOT Return a row with a NULL value for Xday

    2. Select # 1 Returns an error message

    3. Select # 2 Returns an error message

    4. Select #2 does NOT Return a row with a NULL value for Xday

    Derek