，sql拼接有关问题

2012-09-29

求助，sql拼接问题select A.NO || 字符串 AS Msg from ANO是数值类型，要怎样拼才正确[解决办法]select co

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

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

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