John -- good try, but that removes all the spaces from the result. I need the original to remain unchanged except for the removed UPC Code.
removing "112345123451" from "Full Part Description 1 12345 12345 1" should yield "Full Part Description "
>How about
>
>
lcJustPart=STRTRAN(CHRTRAN(mytable.cPartWithUPC,[ ],[]),mytable.cUPC,[])
Jim Nelson
Newbury Park, CA