Date function

Is it possible to retrive the number of days between two dates.
I'm aware of the DateDiff function but I can't figure out how to calculate the number days between two columns containing dates in a table.
All help is welcome
Regrads OISselect datediff (dd,col1,col2) from your table|||declare @.fd1 datetime, @.fd2 datetime

set @.fd1 = '20040513'
set @.fd2 = getdate()

select datediff(d, @.fd1, @.fd2)|||It works perfect :)

Thanks alot both of you|||Try to use BOL next time. Your example described in detail