SQL provides a concatenation operator and string functions to translate, concatenate, and perform other operations on strings.
The functions documented in the following sections are designed primarily to work with strings of characters. Because many of them can also process byte and numeric literal and literal data strings, the term string is frequently used here to refer to all three of these data type families.