SQL provides a concatenation operator and string functions to translate, concatenate, and perform other operations on strings.
The functions in the following sections work with strings of characters. For functions that can also process byte and numeric literal and literal data strings, the term string refers to all these data types.