Replace text

sql

SELECT REPLACE(phone, '-', '') AS digits_only
FROM contacts;

Explanation

Handy for lightweight normalization.

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

Return part of a string.

Open In sheetsqlsame section

Return the current date and current timestamp.

Return different values based on conditions.