copy a record from one table to another (archive)

Hello there

Is it possible to move a record from one table to another to do a archive
with a simple command like move .... ?

Thanks .... jr

============================================
PFISTER + PARTNER, SYSTEM - ENGINEERING AG
Juerg Rietmann
Grundstrasse 22a
6343 Rotkreuz
Switzerland

phone: +4141 790 4040
fax: +4141 790 2545
mobile: +4179 211 0315
============================================