SQL

7.4    String Functions

OK, this is going to be an easy and lightweight section. If you’re familiar with any programming language or at least with spreadsheet formulas, then you know that string operations are an integral part of data processing. We can merge, split, slice, and dice text values as needed, and naturally, DQL supports such operations.

We’ll go over significant string functions in the following sections and inspect the examples together.

7.4.1    Concatenation

In DQL, we concatenate strings by putting the || operator between them. For instance, the expression 'Hello' || 'World' would give out the value HelloWorld. You can put in as many strings as needed.

Let’s see this in action via an example. As preparation, we’ll pull the list ...