>I can't find the HAVING clause in the SELECT from SQL Server... Could that be it?

---

Yes, But it doesn't work the same as fox I always get the following "Type" of error.:

Server: Msg 8118, Level 16, State 1, Line 4
Column 'timehd.empid' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

I understand why I'm getting some of them. So I'll refine my statement to something like... Um, thanks for forcing me to think Sylvain. The following Statement seems to do it:

DECLARE @dNextChkDate DATETIME
SET @dNextChkDate = CONVERT(DATETIME, '04/21/2000',101)-(14*1)

SELECT Timehd.empid, Timehd.date,
CASE
WHEN Timeitms.timeout>17 AND Timeitms.timein>17 THEN Timeitms.timeout-Timeitms.timein
ELSE Timeitms.timeout-17 
END AS Newcolumn
FROM timehd INNER JOIN timeitms 
ON Timehd.timecrdno = Timeitms.timecrdno
WHERE Timehd.date = @dNextChkDate-6
AND Timeitms.jobno <> 'LUNCH'
AND
CASE
WHEN Timeitms.timeout>17 AND Timeitms.timein>17 THEN Timeitms.timeout-Timeitms.timein
ELSE Timeitms.timeout-17 
END >0
ORDER BY TIMEHD.EMPID