Arkadaşlar sql şu kodu
(update _RefScrapOfPackageItem set RefItemCodeName=REPLACE(RefItemCodeName,'_RARE',''),Data=(select Dur_L from _RefObjItem where ID=(select Link from _RefObjCommon where CodeName128=REPLACE(RefItemCodeName,'_RARE',''))) where RefItemCodeName like '%C_RARE')
okutuyorum...