Delete the last 8 characters in a field

[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.

 

[Cheryl Fischer]

You could put the following in the Update to: row of the update query:

Left([MyField], Len([MyField])-8)

 

[Rick Brandt]

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.

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

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