UPDATE ACCOUNT_MASTER SET AccOpenBal = ISNULL(AccOpenBal,0), AccOpenBalCrDr = ISNULL(AccOpenBalCrDr,'Dr'), AccSharePerc = ISNULL(AccSharePerc,0)