>>I know I have this one somewhere in my code but I can't find it. Basically, the goal consists of doing a query and have a condition which implies a calculation on two fields. For example, I need to get all the records where AddDate+NumberOfDay would be less than today.
>
>
>...
> WHERE AddDate+NumberOfDay < DATEADD(day, DATEDIFF(day, 0, getdate()), 0)
>
Thanks, I will take a look at that approach as well.