Question

sql 语句有空格问题

SQL语句调用了两列，并将两列和成列一列，和成后中间又空格，请问高手怎么解决。语句如下：select a+b as c from table；
这样子才列有空格
谢谢你的回答，但是提示TRIM不是可以识别的函数

Answer 1

select rtrim(ltrim(a+b)) as c from table
MSSQL下测试已通过。。

Answer 2

select rtrim(ltrim(a))+rtrim(ltrim(b)) as c from table；

Answer 3

select ltrim(rtrim(a))+ltrim(rtrim(b)) as c from table

Answer 4

select trim(a)+trim(b) as c from table；