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)+’)……
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)+’)……