I want to automate moving values from one row to other by using function like RIGHT, the thing is i need to take from one col (row) 2 last letters and put them into the other column but in the same id/row. ScreenShots should clear some things up.
>Solution :
You can run an update query.
Make a join with the same table and update the new field with your RIGHT() function:
UPDATE tableName INNER JOIN tableName as tableName1 ON tableName.ID = tableName1.ID SET tableName.KodNrProjektu = RIGHT(tableName.NumerProjektu, 2)
Before:
After:
