REPLACE Function

Syntax

REPLACE(string, old_substring, new_substring)

Examples

REPLACE('hello world', ' ', '-')  -- 'hello-world'
REPLACE('(555) 123-4567', '-', '')  -- '(555) 1234567'

Your Task

Standardize phone numbers by removing formatting:

• id
• original_phone
• cleaned_phone (remove spaces, dashes, parentheses, dots)

Only include leads with non-null phones. Order by id, limit to 10.

Hint: Chain multiple REPLACE calls.