Subject manipulating a string From Charlie <tm@tc.com> Date Sun, 20 Mar 2022 10:22:36 -0400 Newsgroups dbase.getting-started Hi...   I need to change some of our in house sku numbers for certain categories in our inventory.  I am thinking I would do something with the substring but not sure if there is a better way. Actually the skus are characters with a liength of 10 or less.   There are two different lengths for different categories.  They always start and end with letters, but in the middle of the string is the mfg part no.   I want to change skus with 4 digits in the middle and add a zero in front so that they all are usable in a new project. So LI2456EX would become LI02456EX. Any suggestions on the best way to do this? Thanks!