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 '  |