>And why would you use like with DateTime? Just for giggles? :-) Besides being invalid it'd also be much less efficient than using = given that like is a pattern matching operation.
>
>+++ Rick ---
Invalid???? It is not. It is perfectly valid. And like is not a much less efficient operation than using =. An expression that has wildcard at the end only, utilizes the index.
If your application is dealing a lot with date\datetimes then there is space to use it.