|| (concatenation operator)

Also written: ||, concatenation, Concatenation

Joins pieces of text into one, such as a name, a bracket and a city. If any piece is NULL the whole result is NULL, so wrap nullable columns in COALESCE.