Home Forums SQL Server 2005 T-SQL (SS2K5) Phone number formatting RE: Phone number formatting

  • September 8, 2009 at 6:46 am

    #1050460

    SELECT SUBSTRING(phonenumber,1,charindex('.',phoneNumber)-1) from table