Removing middle initials

For this query there are many first and last names with some having middle initials with a '.' at the end.

Current result:
Hong, Amy L.
Jackson, Yuri K.
Nguyen, Roy


Desired:
Amy Hong
Yuri Jackson
Roy Nguyen

How can I achieve this with SQL Plus? :confused:
Thanks.

Search for second space in the name using INSTRING function, and use the character position to get substring of name.


select substr(name,1,instr(name,' ',2))
from table