Concatenate strings

sql

SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM contacts;

Explanation

A basic but common formatting function.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing json and string functions

Read a path inside a JSON document.

Open In sheetsqlsame section

Write or replace a value inside a JSON document.

Open In sheetsqlsame section

Construct a JSON object from scalar values.

Open In sheetsqlsame section

Return the first non-NULL expression.

Open In sheetsqlsame section

Transform values into labels inside a query.

Open In sheetsqlsame section

Return current timestamp values.