Subject Re: Eliminate a character in a field From Andy Taylor <andy.taylor.1959@outlook.com> Date Mon, 12 Sep 2022 11:04:54 +0100 Newsgroups dbase.getting-started Nice riposte, erm.... use tablename; replace all fldname with stuff(fldname,3,1,''); use I know technically that's still three, but I'm claiming evens :-) Andy > 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.