5.14. Breaking Apart or Combining Strings

5.14.1. Problem

You want to extract a piece of a string or combine strings to form a larger string.

5.14.2. Solution

To obtain a piece of a string, use a substring-extraction function. To combine strings, use CONCAT⁠(⁠ ⁠ ⁠).