Subject Re: Replacing a substring From Heinz Kesting <Nobody@Nowhere.com> Date Sun, 23 Jul 2023 22:00:53 +0200 Newsgroups dbase.getting-started Hi Charlie, > 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" > Have a look at the STUFF() function or method, if you are going to use that in a OODML, that should do what you're after. > > Also the field part_no is indexed.  Will I need to re-index the table if I can get this done? > You should be fine without re-indexing (assumed you are using MDX indexes), but it wouldn't do any harm if you do so. If you are using NDX indexes, a re-index is required, I think. Just my two cents, Heinz