Thanks for your comments.

You're right about the omission. However, as with most search expressions, there are many working solutions. I didn't mention

WHERE CONVERT(varchar, dateEntered, 103) LIKE '09/07/2002%'

nor did I mention

WHERE CAST(CAST(dateEntered AS char(11)) AS datetime) = '2002-09-07'

(I do show a few of these in Chapter 8 of my book, however.)

As you mentioned, the LIKE version will perform badly, perhaps even worse than the other version that just use functions. I figured there's no reason to include multiple poorly-performing solutions.

Regards,