楼上说的也是一种情况,应该先检查一下。用下面的SQL可把有同样问题的物料一次搞定。
UPDATE INV.MTL_SYSTEM_ITEMS_TL A
SET A.DESCRIPTION = LTRIM(RTRIM(A.DESCRIPTION))
WHERE A.DESCRIPTION LIKE '% ';
COMMIT;
UPDATE INV.MTL_SYSTEM_ITEMS_B B
SET B.DESCRIPTION = LTRIM(RTRIM(B.DESCRIPTION))
WHERE B.DESCRIPTION LIKE '% ';
COMMIT;