Hi,
Thanx for the reply. I am now not storing any version information in the user table. I have added a separate User_Archive table which is something like:

hist_id(Primary Key) Userid ...

I want to create a database design where I want to keep all changes made to a database and the user could revert back to earlier versions. Let say there is a table user which has following values...