split columns in SQL

• gfranklin

  SSC Rookie

  Points: 47

  More actions

  August 12, 2002 at 1:40 pm

  #64162

  I have a column that has multiple entries in it, I would like to split this column into two separate columns. How do I go about doing this? Any help would be greatly appreciated!

  Gabby

  Gabby Franklin

  
  Gabby Franklin
  

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  August 12, 2002 at 2:31 pm

  #434449

  You may want to take a look at the following articles from Steve Jones:

  Using Substring:

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

  Using CharIndex:

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

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.truthsolutions.com/

  K. Brian Kelley
  @kbriankelley