Parsing Full Names

From: <mike_andrew_at_usiva.com>
Date: Wed, 17 Jun 1998 15:47:22 GMT
Message-ID: <6m8oea$j5g$1@nnrp1.dejanews.com>

Any ideas on parsing full names(within the database) into seperate fields?

E.G.

Given in table:
EMP_NAME

---

SMITH JOHN B Desired result in table: EMP_NAME EMP_LNAME EMP_FNAME EMP_MI

-------------------------------  -------------------------- 
--------------------------- ------------------ SMITH JOHN B  SMITH  JOHN  B

Thanks in advance!

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 17 1998 - 10:47:22 CDT