how to split phone number based on - symbol dynamically

• vijay.sap1255

  Mr or Mrs. 500

  Points: 592

  More actions

  July 16, 2015 at 10:53 am

  #305880

  Hi Sql Experts,

  I would like to know how to split the phone number into two columns based on - symbol Dynamically.

  for example

  Phone Number

  123-12323

  1234-1222

  so output should be

  code number

  123 12323

  1234 1222

  Thankyou,

  Vj,

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  July 16, 2015 at 11:09 am

  #1813080

  Something like this should work:

  SELECT PhoneNum

  , CHARINDEX('-',PhoneNum,1) AS ci

  , LEFT(PhoneNum,CHARINDEX('-',PhoneNum,1)-1) AS code

  , RIGHT(PhoneNum,LEN(PhoneNum)-CHARINDEX('-',PhoneNum,1))

  FROM

  (SELECT '123-12323' As PhoneNum

  UNION ALL

  SELECT '1234-1222') a;