String Concatenation

The string concatenation operator allows you to combine multiple string values into one.

In the example on the right we combine peoples first and last names into a full name.

Try adding the field “title” to the output as well.

SELECT fname || " " || lname AS full_name
    FROM tutorial