I need a program, in a certain field of the second position insert one character at a time, and output to the table B "new serial number" field, such as
Take A "number" field, in the second position insert 1 number string, such as the Numbers for X00123, is X10123 after insert, and then output to the table B "new serial number" field,
I checked the STUFF's function, but the STUFF's function can only define A string, and what I need is inserted the table A recorded more than ten thousand characters, how to write code? Please advice,