I have a question regarding the parsing of a column in my Employee table. The NAME column stores the data as follows:
DOE, JON Y
I want to parse the data so that it puts the data in 3 separate columns:
LastName FirstName MiddleInitial
DOE JON Y
How can I do this? What syntax do I use?
Thanks in advance,