Error 245
Severity Level 16
Message Text
Syntax error converting the %ls value '%.*ls' to a column of data type %ls.
Explanation
Microsoft® SQL Server™ returns this message if a character is converted to an integer. For example, these SELECT statements return error 245:
SELECT CONVERT(int, 'A')
-- Or
SELECT CAST('A' AS int)
SQL Server returns this error message because a conversion from a character value to an integer can only be done if it resembles a numeric value. For example, the character 1 (one) can be converted to an integer.
SELECT CONVERT(int, '1')
-- Or
SELECT CAST('1' AS int)
Action
To convert a character to an integer, use the ASCII function, which returns a numerical representation of the character. For example:
SELECT CONVERT(int, ASCII('A'))
-- Or
SELECT CAST(ASCII('A') AS int)