• With SQL Server 2005, I am able to create the table with no error, so the answer is wrong.

    However, when subsequently I query the table, the conversion error appears.

    1 "SELECT col FROM test" succeeds => 1234567ABCD

    2 "SELECT col FROM test WHERE IsNumeric(col)=1" succeeds => 1234567

    3 The query given fails with the conversion error

    Regards, Jon Summers