Joining teo fields in script such as surname and firstname

[#1]

Extracting data from SQL2005 and have two fields surname and forename_1. I want to concatenate these to give surname and forname in one field, what is the best way to do this.

thanks

[Anonymous · Accepted solution]

Add a Load statement on top of your SQL SELECT statement and do a concatenation which pretty straight forward.

forename_1 & ' ' & surname AS ForenameSurname

Or, if you do it in the SQL statement.. I suspect you use + like:

forename_1 + ' ' + surname as ForenameSurname

Not sure about the single/double quotes there.

[#3]

Many thanks. works a treat

[#4]

Hi colleagues, I have used it, but when using + for numbers its sums. Any idea to join without suming numbers?TKS

[#5]

In that case, you may first convert those numbers into strings and then concatenate them.