You should be able to switch them with something as simple as [UPDATE](https://www.sqlite.org/lang_update.html) t SET c4 = c3, c3 = c4; And if needed add in constraints on ProjID or InsertDate to a WHERE clause.
You should be able to switch them with something as simple as [UPDATE](https://www.sqlite.org/lang_update.html) t SET c4 = c3, c3 = c4; And if needed add in constraints on ProjID or InsertDate to a WHERE clause.