Suppose a table has firstname and lastname as its fields and we want to show full name on the screen or in a report. The first expression that comes to mind is like :
SELECT TRIM(lastname)+' , ' + firstname from table .......
Or
SELECT ALLTR(lastname)+' , ' + firstname from table .......
However a easier way is :-
SELECT lastname - (', '+firstname) from table .........
The '-' is a another concatenation operator that removes trailing blanks from the element preceding the operator then joins two elements
