Subject Replacing a substring From Charlie <tm@tc.com> Date Sun, 23 Jul 2023 15:08:09 -0400 Newsgroups dbase.getting-started 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.