I have a database called “SBOD”
In it there is a field called “Book”
Sample data in that field is “Bowyer-Small-Plain-Normal (KQWGBPD)”
It will always contain a skill (in this case Bowyer) preceding the first dash. I want to copy the data out of book up to the dash (In this example “Bowyer”) and put in in my field called “Skill” in the same database.
Can someone give me the full UPDATE statement required to do this?