UPDATE SUPPLIER SET Address2='', Address3='', Address4='', Opening=0, DbCr='Credit', NameAR='', Address1AR='', Address2AR='', Address3AR='', Address4AR='', Activities='', Mobile='', fill=1, SupStatus='Active', AccountId='', CrLimit='', CrDays=''