Remove the letters (-PARTS) from a field
I have a database that a user has corrupted by adding words on the end of and Index field....
Now I need to remove them without removing the index in that field
Can you help
Example would be [18-007528-00-PARTS]