select ItemCode,(case when t0.ItemCode='BHPSBP0010' then 'BHPSBP00101' else 'Not Match' end) as Testing from oitm t0
|
select ItemCode,(case when t0.ItemCode='BHPSBP0010' then 'BHPSBP00101' else 'Not Match' end) as Testing from oitm t0
|