If you want to extract numbers all the numbers (8702000118) from the following string “BlaBla Hill is – 870-200-0118 abx” just use the code below:……
This will teach you how to format a phone number from 1234567890 to (123) 456-7890. SQL Server 2008: SELECT [Phone] AS [Phone Number] , ‘(‘+(SUBSTRING(Phone,1,3)+’)……