转载地址:http://blog.sina.com.cn/s/blog_4bce1a290100g79f.html
数值型:
select cast(a as varchar(10))+'--'+cast(b as varchar(10)) from tablename
字符型:
select a+'--'+b from tablename
---------------------------------------------------------------
---------------------------------------------------------------
字符型:
varchar
select a+'--'+b from tablename
char
select rtrim(a)+'--'+rtrim(b) from tablename