hi to all. i used access98 and have a table with 200,000records. i had a problem with one of the field within my table, and i realy need some help. i make a query for a newtable like this.

SELECT tblPoliticalPersonalities1.* INTO newTable
FROM tblPoliticalPersonalities1
WHERE (((tblPoliticalPersonalities1.NameSuffix) Like "Jr") AND ((tblPoliticalPersonalities1.FirstName) Like "*J"));

now, what i want to do is to trim or delete the last character "J/j" from my tablefield FirstName?

only i know is to make an update query. but i dont know how to play around with string from fieldnames.. any idea?
all help i will considerate..
thanks in advance..

Mabuhay!!!

__________________
Mabuhay!!!

Mabuhay,

Run this update query on your new table:

UPDATE newTable SET FirstName =Left(FirstName, Len(FirstName) - 1)

That'll remove the final character from any data stored in your FirstName field.