update query?

[Zorro1265]

I want to seearch my table and add a period to each text string that doesnt have a period at the end of it. Should I use a query to do this or does someone have a bit of code that would do it. I don't want to type 600+ periods.
Zorro

 

[THoey]

If it is just one field, I would use a query:

UPDATE MyTable
SET MyTable.MyField = MyTable.MyField & "."

You will have to change the names to suit your needs. You can also do multiple columns in the same table at one time if necessary.

Hope that helps...
Terry M. Hoey

 

[Databaseguy]

I'll piggyback Terry's suggestion here....

UPDATE MyTable
SET MyTable.MyField = MyTable.MyField & "."
WHERE Right([MyTable].[MyField],1)<> &quot;.&quot;
Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[Zorro1265]

Thanks guys! Zorro