I ran the following code, which was working until I added an IIF statement in the select clause is giving me problems in compiling; it says Error in line 193: Command contains unrecognized phrase/keyword.

	SELECT ;
			ct.Name, cv.GrpID, cv.GrpNum, cv.Date, ;
			cv.Seq, aa.EMP_ID, cv.CovCd AS PlanKey, ;
			SPACE(8) AS BnftName, cv.PREM, cv.Bill_Date, ;
			IIF (NOT EMPTY(aa.Depos_Date), cv.Prem, 0000000.00))  AS Collected ;
	FROM BLCEXTAA aa ;
	JOIN BLCEXTCV cv ;
		ON aa.GrpID+aa.GrpNum+aa.Date+aa.Seq=cv.GrpID+cv.GrpNum+cv.Date+cv.Seq ;
	JOIN GRPEXTCT ct ;
		ON cv.GrpID=ct.GrpID ;
	WHERE ;
		aa.Stat_Code="P" AND ;
		cv.GrpID=lcGrpID AND ;
		cv.CovCd=lcPlanKey AND ;
		YEAR(cv.bill_date)=2010 ;
	ORDER BY cv.GrpID, cv.GrpNum, cv.CovCd ;
	INTO TABLE tmpData