Guys,

How do I round this UP to the actual number of weeks ?

datediff(d,c.startdate,c.enddate)/7 as ContractPeriod

Example, 10/10/05 - 15/06/07 is 87.57 weeks, I need to show this as 88.

Thanks
Bob