Urgent help needed!!

[balajiyes]

Hi I am not able to figure out the reason but if ur columns are VARCHAR type, sometime the value may not match. try using TRIM() option.

update temp_schedrcpts u
set manu_item = (
select imlitm from f4101 x
where TRIM(x.imaitm) = TRIM(u.legacy_item))
where exists (
select 1 from f4101 x
where TRIM(x.imaitm) = TRIM(u.legacy_item));

Cheers!