求助，sql拼接问题
select A.NO || '字符串' AS Msg from A

NO是数值类型，要怎样拼才正确

[解决办法]
select convert(varchar(10),A.NO)+'字符串' AS Msg from A
长度10自己改