
SELECT item_id from 0p4_item where item_code IN ('SUN-P 105-6042','SUN-P 105-6050','SUN-P 105-6069','SUN-P 105-6077','SUN-P 105-6085','SUN-P 105-6093');

update 0p4_item set item_code='SUN-PP 105-6042',art_no='PP 105-6042'	where item_code='SUN-P 105-6042';
update 0p4_item set item_code='SUN-PP 105-6050',art_no='PP 105-6050'	where item_code='SUN-P 105-6050';
update 0p4_item set item_code='SUN-PP 105-6069',art_no='PP 105-6069'	where item_code='SUN-P 105-6069';
update 0p4_item set item_code='SUN-PP 105-6077',art_no='PP 105-6077'	where item_code='SUN-P 105-6077';
update 0p4_item set item_code='SUN-PP 105-6085',art_no='PP 105-6085'	where item_code='SUN-P 105-6085';
update 0p4_item set item_code='SUN-PP 105-6093',art_no='PP 105-6093'	where item_code='SUN-P 105-6093';