CanMan2004 Posted August 27, 2006 Share Posted August 27, 2006 hi allI have loads of rows in my database and I want to run a query to copy the contents of one field in a specified row to another field on the same row, basically passing data from one field to another but the data and the data that is passed is always on the same row.Can anyone help me?Thanks in advanceDave Quote Link to comment Share on other sites More sharing options...
trq Posted August 27, 2006 Share Posted August 27, 2006 Ive not tried it but a simple UPDATE should work.[code]UPDATE tbl SET sourcefield=destfield;[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.