You are not going to be able to do this with Query,
You need to use a language that allows for scan and substring.
With the format you defined: LASTNAME, FIRSTNAME MI
Start at pos 1 and scan for ‘,’. When found all data preceding the comma is LASTNAME.
Now start at the position of the comma +1 and scan for a blank.
When found, data from the beginning scan position to the blank is FIRSTNAME.
Data after the blank is MI