如果AB为数值型:
select cast(a as varchar(10))+'--'+cast(b as varchar(10)) from tablename
字符型:
select a+'--'+b from tablename
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