Drop last character
I would like to know how to update a field in a table by removing the last one or two characters.
I have values in a column called ID
I want to drop the *. some rows have two * and some only one.