Character operators

You can concatenate characters. In the following, last_name is 'JONES ' and first_name is 'ROBERT '.

Operator

Concatenation

Example

Result

+

Keep trailing blank characters

first_name + last_name

'ROBERT JONES '

-

Move trailing blank characters to the end

first_name - last_name

'ROBERTJONES '