Extract substring

sql

SELECT SUBSTRING(phone FROM 1 FOR 3) AS area_code
FROM contacts;

Explanation

Substring function syntax differs slightly across SQL dialects.

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

Join multiple strings into one value.

Open In sheetsqlsame section

Convert strings to uppercase or lowercase.

Open In sheetsqlsame section

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

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.