UPDATE  CM_SUPPLIER   SET  ACC_NAME_OUT = ACC_NAME, ACC_NUM_OUT= ACC_NUM, BANK_NAME_OUT= BANK_NAME, ACC_NAME='', ACC_NUM='', BANK_NAME ='' WHERE ACC_NAME NOT LIKE N'%Bản Việt%' or ACC_NAME NOT LIKE N'%BVB%'

UPDATE CM_SUPPLIER SET ACC_NUM ='00'+ACC_NUM WHERE LEN(ACC_NUM)=11 AND ACC_NUM IS NOT NULL AND ACC_NUM <>''


UPDATE CM_SUPPLIER SET ACC_NUM ='0'+ACC_NUM WHERE LEN(ACC_NUM)=12 AND ACC_NUM IS NOT NULL AND ACC_NUM <>''