Concatenating text with field

I am trying to concatenate some text with a field for a total column in a report. What is the best way to do this?

Find more posts tagged with

I have a text field which shows the latest load time on a dashboard

Data last refreshed: GetVariable('IncrementalLoadMaxFormatted')

I also use concatenation in a script in a scripted source which adds a slash between two columns

[Won or Lost Reason] = IFNULL([Reason Won.Description],'No Reason') + '/' + IFNULL([Reason Lost.Description],'No Reason')

And in a query which adds a hyphen between Scheme ID and Scheme

SELECT USING OUTER JOIN [Scheme Attributes.Scheme ID] + ' - ' + [Scheme Attributes.Scheme],

[Scheme Attributes.Scheme ID] FROM [ALL]

Thank you!