I need to bring apart a field containing supervisor names into two fields containing the supervisors first name and last name. The current concatenated field uses a comma to separate the two values. How can I write a query that will give me the first name and last name of everyone in the field as two separate values?
Needed Result: (two fields)
Last Name First Name
I have this query that gives me their last names, but it also includes the comma, which I don't need, but I'm not able to figure out how to drop the comma or get their first names.
select LEFT(p_supervis, charindex(',', p_supervis)) as p_supfname from persnl