I have three fields in SQL..

Full Name, Last Name, First Name

Full Name = Doe, John
Last Name = NULL
First Name = NULL

What SQL statement would be best to parse the name and have it so I can get:

Full Name = Doe, John
Last Name = Doe
First Name = John


Any advice would be appreciated.

Thanks!