UPDATE  `vdmpro` SET  `NOMMASK` =  "VB2" WHERE  `CDARTICLE` LIKE  "REG%"

UPDATE  `vdmlig` SET  `MARQUE` = RIGHT(  `CDARTICLE` , 1 ) WHERE  `N_FACTURE` >=143100

UPDATE  `vdmlig` SET  `MARQUE` = RIGHT(  `CDARTICLE` , 1 ) WHERE  `N_FACTURE` >=142000

UPDATE  `vdmlig` SET  `MARQUE` = RIGHT(  `CDARTICLE` , 1 ) WHERE  `N_FACTURE` >=142000 AND  `MARQUE` =  "F"

UPDATE  `vdmlig` SET  `MONTANT_HT` = ( QUANTIT * PXARTICLE ) / 1.20 WHERE  `N_FACTURE` >=142950 AND  `MARQUE` =  "F"

UPDATE  `vdmlig` SET  `CLVOL` = QUANTIT * 0.75 WHERE  `N_FACTURE` >=142900 AND  `BLL` =  "B"

UPDATE  `vdmlig` SET  `CLVOL` = QUANTIT * 1.5 WHERE  `N_FACTURE` >=142900 AND  `BLL` =  "M"

UPDATE  `vdmlig` SET  `CLVOL` = QUANTIT * 0.75 WHERE  `N_FACTURE` >=142900 AND  `BLL` =  "R"

UPDATE  `vdmlig` SET  `CLVOL` = QUANTIT * 0.70 WHERE  `N_FACTURE` >=142900 AND  `BLL` =  "X"

UPDATE  `vdmlig` SET  `GROUPE` = LEFT(  `NFACTNLIGN` , 5 ) WHERE  `N_FACTURE` >=142900

UPDATE  `vdmlig` SET  `NOMEMP` =  "220421421" WHERE  `N_FACTURE` >=143100 AND  `CDARTICLE` LIKE  "10%"

UPDATE  `vdmfact` SET  `Change` = 1 WHERE  `N_FACTURE` >=143100 AND  `pays` =  "FRANCE"