SQL help on a name dilemma
- by Ardman
I have a column which has surname and firstname plus salutation in. e.g.
Bloggs,Joe,Mr
I need to break this out into Bloggs Joe Mr as 3 seperate columns. Any ideas appreciated.
How, the other thing is I won't know how many commas are in the initial column.