STRING_expr1 + STRING_expr2
The string concatenation function returns the concatenation of string_expr2 to the end of string_expr1.
Select first_name+' '+last_name from customer