Hi all, I am trying to join two columns
select Name, (ColumnB+ColumnC) as Merged
but when I do this I end up with a few spaces before every item in the merged column. I tried
Select Name, trim((ColumnB+ColumnC)) as Merged but then my report doesn't work at all.
Surely I'm just being an idiot here, but could someone help please?