Query Results

Run a query to see results.

Database Schema

Schema undefined.
Code Editor
Learn
Date, Number, and String Functions

Strings

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.

Report a Bug
If you see a bug or any other issue with this page, please report it here.