Concatenate strings

sql

SELECT first_name || ' ' || last_name AS full_name
FROM users;

Explanation

String concatenation syntax varies by dialect; CONCAT() is also widely available.

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 String Functions

Convert strings to uppercase or lowercase.

Open In sheetsqlsame section

Remove spaces from the left, right, or both sides.

Open In sheetsqlsame section

Return part of a string.

Open In sheetsqlsame section

Substitute one substring for another.

Open In sheetsqlsame section

Return the current date and current timestamp.

Return different values based on conditions.