getting spaces while concatenating column and string

hi all,

i am getting spaces while concatenating column , string.

below example

select empname++'test' employee

result: mandava                test

expected result: mandavatest

regards,

mandava.

select ltrim(rtrim(empname))+'test' employee

---

hope helps!!

SQL Server  >  Getting started with SQL Server