Thanks Gail. I suspected that, and thought using a CAST and CONVERT wouldn't be too helpfull either.

If a selection is required on the date part of a datetime field what would be the best way of doing it?

Another method I have used is using DATEDIFF to check the number of days difference, but does this suffer the same kind of penalty?

Thanks,

BrainDonor