>I'm not sure about differences in optimization, but the latter query should execute faster. The reason being that the date function will have to be called and it will have to return its value for every record in the table. In the latter case, it simply a straight comparison.
Thanks, this is what I thought. I have in a few places in my application some SQL that I will move from sample 1 to sample 2. :)