I have a .dbf database table where I have a list of item codes in a column KITNO that need to be replaced with new codes.
I am using Borland Database Desktop v7 to make changes, using the sql editor.
to replace 1 itemcode at a time I would use
set kitno = "newcode"
where kitno = "oldcode"
What I would like to do though, is replace a whole list of "newcode" with corresponding "oldcode". There is far too many to want to do one at a time :)
Any suggestions on how to do this would be appreciated.