hi,
anyone knows how to move/transfer records from field1 to field 2?


thanks

update mytable set field2=field1
should do the trick.. unless you want to transpose fields ie field1.oldvaule->field2 and field2.oldvalue to field1

great!
but, what do you mean by transpose? can it delete records from field1 and copy it to field2? bcause after i copy the field1 to field2 i will delete it from field1. its like moving the records.

thanks

you can simply manipulate data using SQL. however if you want to move the value of field 1 to filed 2, and the value of field 2 to field 1 (ie transpose the values in field 1 to field2) in one operation you would need some other mechanism...

if you want to blank field 1 you could
update mytable set field2=field1, field1=""

this is impossible

fields don't have records