Try

STRTRAN(STRTRAN(myfield, "-G", ""), "-B", "")
* OR 
LEFT(myfield, RAT("-", myfield)-1 )

>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.