I have this SQL Statement (VIEW) in VFP5.0a and was wondering how I would get the same functionality of the IIF() in SQL Server 7.0.

SELECT Timehd.empid, Timehd.date,;
  IIF(Timeitms.timeout>17.AND.Timeitms.timein>17,Timeitms.timeout-Timeitms.timein,Timeitms.timeout-17);
 FROM  prewel!timehd INNER JOIN prewel!timeitms ;
   ON  Timehd.timecrdno = Timeitms.timecrdno;
 WHERE Timehd.date = ?m.dNextChkDate-13;
   AND Timeitms.jobno <> "LUNCH";
 GROUP BY Timehd.empid, Timehd.date;
 HAVING Timeitms.timeout>17;
 ORDER BY Timehd.empid