I am using SQl database

Table Name is : User

structure of the table is

CODE NAME

1010 ABC
1020 XYZ
1030 NIY

CODE Field is Primary Key

PHysically i want to interchange the records. For this I want to implement the following steps in VB

Assigning record to a variable
X = Source Record (any one Record)
Y = Target Record (another record)
Z= Empty

Interchaing the record
Source Record = Z
Target Record = X
Source Record = Y

This is i want. Please can u help how to do this with VB


thanx in advance

by
yasi