SQL Server REPLACE Function By Practical Examples

PHOTO EMBED

Fri Mar 04 2022 08:13:50 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

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;
content_copyCOPY

https://www.sqlservertutorial.net/sql-server-string-functions/sql-server-replace-function/