It is necessary to insert / replace into the column a part of the value from another column. For example, there is a single column value "Duplicata B02341543". In the other column, you only need to insert "B02341543". For each line, the word "Duplicata" is preserved, but the value "B02341543" changes.

    3 answers 3

    update table set field2=substring(field1,10,len(field1)) 
       UPDATE <YourTable> SET <updatedField> = SomeOperation(<someField>) 
         UPDATE table_name SET filed2 = SUBSTR(filed1,11); 

        11 is the length of the word "Duplicata" and a space.