Thats what I thought about doing at first, but I didn't find the date type in SQL Server. Only smalldatetime and datetime. It looked to me like the smalldatetime still retains the time, so it didn't help me any. Using the AND on the datetime going from 12:00AM to 11:59PM is working fine. I was just wondering if there was an easier way than building that statement; although, building that statement isn't hard. Thanks for the help.
Randy Belcher
AFG Industries, Inc.