Parse names

[Deam]

I am creating a dts package(Access97 to SQL 7) which would clean data on its execution. The Contact name, for example is Amy D Smith, I need to parse it out into three fields - First Name,Middle Name,Last Name. Some People may not have a Middle Name or a Last Name.If there is no last name then i need to put in a dash.

Can anybody help me with the code in SQL7.0 used for parsing ? or maybe point me to where on the net I can find it.

 

[anhmytran]

I am a newbee in SQL Server.
I know this task can be done easily with VB functions such as:
InStr(), Left(), Mid(), Right(), Replace(), Len() functions.