Subject Re: Eliminate a character in a field From Mervyn Bick <invalid@invalid.invalid> Date Mon, 12 Sep 2022 08:36:01 +0200 Newsgroups dbase.getting-started On 2022/09/11 12:54, Andy Taylor wrote: > Mervyn, > > Nice to see you have retained your grasp of XDML. :-) > However, I'm going to do a Romain on you... > > use tablename > replace all fldname with stuff(fldname,3,1,'') > use > > 3 lines instead of 5 > > chortle, > Andy I'm switching to Romain-mode as well. :-) Try this for size. update tablename set fldname = substring(fldname from 1 for 2)||substring(fldname from 4 for 8) It's a bit "messy" but it's only 1 line. Mervyn.