试试这个

SELECT IDNO, cast(ARREARS as int) AS COMP_ARREARS FROM TRIAL

请参考以下链接：

CAST和CONVERT（Transact-SQL） [ ^ ]

SQL SERVER - 将文本转换为数字（整数） - CAST和CONVERT [ ^ ]

SQL Server：CAST功能 [ ^ ]

refer these links:
CAST and CONVERT (Transact-SQL)[^]
SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT[^]
SQL Server: CAST Function[^]