When using strings (or character fields), a nice alternative to the CONCATENATE
statement is the &&
operator. The example shows it all.
str = 'Hello' &&
' my' && ' friend'.
There is also the & literal, which does something very similar, but with a maximum of 255 characters (performed at compile time).