Can anyone suggest the syntax for extracting first name and last name from an email address within a sql table.

Ex.
John.Doe@abc-stago.com

I need to insert first name : John and last name: Doe to a different table.

Thank you,
Daniel