replace horse_name with left(horse_name, at("(", horse_name)-1))
nOcLeft=occurs("(", cYourString) nOcRight=occurs(")", cYourString) do while nOcLeft=nOcRight and nOcLeft>0 nAtLeft=at("(", cYourString) nAtRight=at(")", cYourString) cYourString=stuff(cYourString, nAtLeft, nAtRight-nAtLeft+1, "") nOcLeft=occurs("(", cYourString) nOcRight=occurs(")", cYourString) enddo