Home Forums SQL Server 2005 T-SQL (SS2K5) Phone number formatting RE: Phone number formatting
Sirish-791018
SSChasing Mays
Points: 644
More actions
September 8, 2009 at 6:46 am
#1050460
SELECT SUBSTRING(phonenumber,1,charindex('.',phoneNumber)-1) from table