Well, I can’t think of a way to avoid the parse-concat approach, but you can do it in one operation.
SET name = CONCAT(LEFT(name,INSTR(name,’ ‘)-1),RIGHT(name,LENGTH(name)-INSTR(name,’ ‘)))
I used the INSTR function to find the first blank space position in case it is not always in the second position, but it could be avoided if it does.
What is wrong with a simple expression like the following?
set Name = rtrim(left(name, 2)) + substring(name, 3, 255)
If there is a blank in position 2, it will be removed. If not, then nothing changes.