What is the correct syntax to search a table for an asterisk

[webaddict]

Our Access 2003 db has 2 asterisks placed after the last name and I would
like to remove them from the db. I am hoping that I would not have to do this
by hand as there are over 6,000 entries.

Please advise

 

[fredg]

Our Access 2003 db has 2 asterisks placed after the last name and I would
like to remove them from the db. I am hoping that I would not have to do this
by hand as there are over 6,000 entries.

Please advise

Create an Update query:

UPDATE YourTable SET YourTable.[LastName] =
Replace([LastName],"*","");