Concatenation

Concatenation is a simple concept from linguistics, mathematics, and computer science. It is a way of making a new word (or string), by joining two (or more) other strings. For example, the concatenation of "snow" and "ball" is "snowball".

In most programming languages, if we write x = "snow" + "ball", then the value of x will be "snowball". But to do the same in SQL we would write "snow"||"ball".