Subject Re: Eliminate a character in a field From Mervyn Bick <invalid@invalid.invalid> Date Sat, 10 Sep 2022 21:47:41 +0200 Newsgroups dbase.getting-started On 2022/09/10 21:27, Charlie wrote: > Can;t figure this out although it should be easy..... > > I have an 11 character field where the first 3 characters are LGB.  The rest are unique.  I would like to eliminate the B in all rows so instead of being for instance LGB66554499 it would look like LG66554499. > > How can I do this?  Thanks much. cStr = 'LGB66554499' cNewstr= stuff(cStr,3,1,'') ?cNewstr Untested but the following should sort out the entire table. Make a back up first. use tablename scan fldname = stuff(fldname,3,1,'') endscan use Mervyn.