SQL语句错误 Error converting data type varchar to varbinary.

SQL语句错误 Error converting data type varchar to varbinary.
查询语句
select CONVERT(binary, cast('0x01111' as char),1)
错误原因 convert将表达式转换为二进制时应始终保持偶数位因此将0x01111改为0x001111即可
参考链接 https://stackoverflow.com/questions/27060150/error-converting-data-type-varchar-to-varbinary-mssql-when-converting-to-intege