Thanks, Noel, that nested CASE does exactly what I want, minus the cheese factor of my earlier solution.

--Matt

When I try to run that, I get the same error (syntax error converting datetime from character string), yes.

The crappy workaround I've developed is:

SELECT txtDate

FROM Table

WHERE

CASE

WHEN ISDATE(...

Ah! Now we're getting somewhere.

Massaging your SQL into:

Select dtValidDates.txtDate from

(SELECT txtDate

FROM Table

WHERE ISDATE( txtDate ) = 1) dtValidDates

WHERE dtValidDates.txtDate BETWEEN '01/01/2003 00:00:00' AND

'04/30/2005 23:59:59'

gives me 1 of the 4...