String manipulation can be useful to derive information from columns. We’ll cover a couple of the common string functions here.

A common use case for string manipulation in SQL is concatenation of strings. In SQLite, this is written as

SELECT string1 || ' ' || string2;

For example, the bakeries table contains both city and state columns. In order to create a route for these columns, we use the || function to concatenate them as in the following query:

SELECT city || ' ' || state as location FROM bakeries;

String functions are again, very database specific, and it is best practice to consult documentation before proceeding.



Combine the first_name and last_name columns from the bakeries table as the full_name to identify the owners of the bakeries.

Be sure to add a space between the names in the full_name as shown in the example.

Sign up to start coding

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?