Concatenation Operator. ANSI SQL defines a concatenation operator (||), which joins two distinct strings into one string value.