Subject Re: Replacing a substring From Charlie <tm@tc.com> Date Mon, 24 Jul 2023 16:08:01 -0400 Newsgroups dbase.getting-started Thanks for the replies.  I don't think I had ever heard of the stuff function.  That seemed to work great! Charlie Wrote: > I am wondering how to change text like LI10000 TO LH0000? > > I have tried this: > USE MASTER.DBF > REPLACE substr(part_no,1,2) with "LH" for mfg = "LIONEL H O SCALE" > > But come back with error 'expecting with' > > Also the field part_no is indexed.  Will I need to re-index the table if I can get this done? > > Thanks much for any help.