To compare dates in T-SQL use DATEDIFF function and you won't need to warry about the time part.

Select *

FROM tablename

WHERE DATEDIFF(day, '1/1/2005’, datefield) >...

Hi Henk

You can try this option. It should be faster as Join is more efficient then Where condition.

select a.*

from YOURTABLE a

   left outer...

Hi Dan, this question appears to be fairly common with no easy answer due to limitations of UDF.

Try this script below, hopefully it will do what you want.