> Select * From Calls Where DatePart(Month, CallDate)=12 and DatePart(Day,
> CallDate)=3 and DatePart(Year, CallDate)=1997 and
> FramedAddress='206.28.213.101'
Logically, the first should be faster, since its only two compares
per record. DatePart() is going to have even a higher overhead,
since the first is just comparing two longs, where as datepart()
has to disect the date, break it up, and then compare, three
times actually. :(
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com