SELECT first_name, last_name, phone, REPLACE(REPLACE(phone, '(', ''), ')', '') phone_formatted FROM sales.customers WHERE phone IS NOT NULL ORDER BY first_name, last_name;
SELECT first_name, last_name, phone, REPLACE(REPLACE(phone, '(', ''), ')', '') phone_formatted FROM sales.customers WHERE phone IS NOT NULL ORDER BY first_name, last_name;