UPDATE CsItem
SET YeRef = 7051
WHERE ItemRef IN (688421, 688413, 688405, 688438, 688446)


To run the above
- On any ONE machine.
- Go to Maintenance > Advanced > SQL Entry
- Cut and paste the SQL into the 'SQL String to be processed' box
- Click Process
- The SQL has run so you can now close the screen


--
---------

Robert Martin
Development Manager


Ph 03 377-0495
fax 03 377-0496
email rob@...

Wild Software Ltd
www.chreos.com

Please forward all support queries to support@...
so we may respond to your query as quickly as possible.