Need to split the big string into 3 small strings

• jgehani85

  Grasshopper

  Points: 11

  More actions

  October 30, 2014 at 1:54 am

  #312587

  Say

  I have a string : "CD 000000000000161300000000"

  Need to split into three strings into SQL 2012 need command for that ....

  First string |Second String|Third string

  CD 00000000|00001613 |00000000

  If any one found the split string command pls mail me at

  jgehani85@gmail.com ( small "j" jgehani )

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  October 30, 2014 at 2:04 am

  #1755702

  Did you try SUBSTRING?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP