> new.midname,; > LEFT(new.lastname, 15) AS lastname,; > LEFT(new.employer,35) AS employer,; > LEFT(IIF(NVL(inservice.AcctType,1) = 1, pmplan.planname, inservice.bucketname),50) AS plan_name,; > STR(ROUND(new.er_perves,0),3) AS er_perves,; > STR(ROUND(new.oth_perves,0),3) AS oth_perves,; > new.plantype,; > new.webenable,; > new.invnum,; > STR(new.planid,10,0) AS planid,; > IIF(pmplan.doProjBen = .T. AND new.AcctType = 1, new.avg5yrcont, 000000000.00) AS avg5yrcont,; &&****************** Retirement Account OK, InServ, Edu 0 > ' 0' AS retireAge,; > old.pin,; >