Separate one column to multiple columns

• peter_ping

  SSC Rookie

  Points: 31

  More actions

  September 16, 2002 at 8:21 am

  #158903

  There is a column like this: John Smith,Dept of HR,ABC Company,123 Main St,New York,NY 10021. How do I to separate this one column to multiple columns by comma delimiter as following format: John Smith|Dept of HR|ABC Company|123 Main St|New York|NY 10021.

  Thanks. - Peter

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  September 16, 2002 at 11:19 am

  #436612

  use SUBSTRING and CHARINDEX

  http://www.sqlservercentral.com/columnists/sjones/tamestrings2.asp

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones