String Manipulation - URGENT

[nate100]

I have to update records where the string that I need to update is at the end of:

For example

INSH656

needs to be updated to:

INSH789

It could also be

IND656 updated to IND789.

It can also be
656IND updates to 789IND.

What I need is to find 656 anywhere in the string and update it to 789.

THanks

 

[MrMoo]

Not sure how you're getting your original string but once you get it something like this should work.

orig_string = Replace(orig_string, '656', '789')