If datetime values stores with time part than it'll affect you. You do realize that

TableName.FieldName between '2010-04-01 00:00:00' and '2010-05-01 00:00:00'

will ignore all records for '2010-05-01' with none-zero time?


>Thank you for the explanation. I sort of have to use the BETWEEN since this is the syntax used in a 3P tool I am using. And since I am only concerned about comparing dates and not times, maybe the the fact that BETWEEN does not handle time part properly won't affect me. Or maybe I will take the time and change the 3P tool (I have the source code).
>