I have a field called name with a list of users. On the end of each name is either B or G: This denotes good or bad. What I would like to do is to remove the G and B from each record: Typical data looks like:

Name

Tony-G
Paul-G
Veronica-B


I basically want to remove the -B or -G from the end of the name.