I am working with a table that has names stored like this:

Dent~Aurthur
Servo~Tom
Gently~Dirk

I need to run a select query that will take the Name field and split it up so that it puts the Authur in a FirstName Field and Dent in the LastName field. Is that possible using a query?