Update substr

We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. TIA, Michael Stelly. MaxGay Posted February 17, 0 Comments. Just a thought. Steve Shurts Posted February 17, 0 Comments.

David Webb Posted February 17, 0 Comments. David, Thanks for the help. Viewed 1k times. For example: Row before update: some text a ba ba b a ID sffjhdsf further part etc etc Row adter update: some text a ba ba b a further part etc etc how to achieve that?

Plenty of examples online. Add a comment. Active Oldest Votes. Does this help? Paul Vernon Paul Vernon 3, 1 1 gold badge 7 7 silver badges 21 21 bronze badges.

Daniel Lema Daniel Lema 2 2 silver badges 8 8 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Didn't really work as expected. Thanks — user Thanks very much for your help. Worked a treat — user This is what worked for me. So, to remove 4 characters, this value would be 5. Show 2 more comments.

Romesh Romesh 2, 2 2 gold badges 21 21 silver badges 44 44 bronze badges. Linga 9, 9 9 gold badges 47 47 silver badges 94 94 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.