moving a record from one table to another

[BownGoomimb]

Hi, I'm using asp.net beta 2 and sql 2000. I need to move one record from one table to another table in the same database. Does anyone know the best way to get this done?<BR><BR><BR>thanks,<BR>oliver