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.
Neil Lewis
IT R&D Manager
Velmore Ltd