>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)
--sb--