Delete the last 8 characters in a field

  • Thread starter Thread starter David Peterson
  • Start date Start date
D

David Peterson

How can I use an update query to delete the last 8 characters from a field
in my table?

The characters to delete are "Level II". Always at the end but the field
length varies.
 
You could put the following in the Update to: row of the update query:

Left([MyField], Len([MyField])-8)
 
David Peterson said:
How can I use an update query to delete the last 8 characters from a field
in my table?

The characters to delete are "Level II". Always at the end but the field
length varies.
Click to expand...

Test on a *Copy* of your table first....

UPDATE YourTableName
SET YourFieldName = Left([YourFieldName], Len([YourFieldName])-8)
 
Back
Top