removing characters in a text string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Last Name field that has last names in it. On some of the names there is a ' at the end of the name. I would like to remove this in a query. Because the names have different number of characters, I don't know how to do this. Help hasn't helped me. Thanks.
 
Frustrated,

First, make sure you have a backup copy of your data. Make an Update
Query. In the query design grid, in the Update To row of the Last Name
field put...
Left([Last Name],Len([Last Name])-1)
.... and in the Criteria of this column put...
Like "*'"
 
Back
Top