update tbl_PromotionMasterDetails set Value1='1' where promoTypedesp='CustType' and Value1='EasyPay' update tbl_PromotionMasterDetails set Value1='2' where promoTypedesp='CustType' and Value1='SAIB' update tbl_PromotionMasterDetails set Value1='3' where promoTypedesp='CustType' and Value1='SAIB Staff' update tbl_PromotionMasterDetails set Value1='4' where promoTypedesp='CustType' and Value1='Virgin Mobile' update tbl_PromotionMasterDetails set Value1='0' where promoTypedesp='CustType' and Value1='None'