It may miss some records because dateme values are stored with accuracy one three-hundredth of a second. IOW, any records with meetings.begintime >= '10/31/2002 23:59:59.003' will be missed.


>When using the between clause in the SQL Server Select statement, such as:
>
>Select meetings.lastname,firstname frin dbo.meetings
>where meetings.begintime between '10/01/2002 00:00:00' and '10/31/2002 23:59:59'
>
>Will this include all records for the month?
>
>Thanks
>Kirk