• I tried in SQL 2005. It worked fine.

    While inserting, it perform implicit conversion of numerals into varchar.

    But if SELECTed, it does not convert it.