pretty simple soultion.... I think

[bowfine]

Greetings All,

The set-up:
I have a full name field in a access database table that has last, first and Initial.

Doe, John I

I want to seperate the field into 3 different fields. One for first name, one for last name and one for initial.

Any idea on the easiest way to do this in access?


Thanks

[PeOfEo]

if you ar eusing asp as your server side language or asp.net use a replace statement to move the different parts into different feilds of the data base when you are first inserting the data. Or maybe if you have a specific feild length you can cut off anything over or under the length or something to sort the parts.