Columns

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Taftheman
    New Member
    • Nov 2006
    • 93

    Columns

    Hi, I have imported data. One of the fileds have data needs to be split into three. Example title forename surname is in one column. I need to split this into 3 columns. Can somebody help. I was thing of doing this in a query but i don't know where to start.
  • BHTanna
    New Member
    • Aug 2008
    • 31

    #2
    If it has seperator " "(Space) then use charindex and diff string functions...

    Comment

    Working...