datediff (today - date) for MS SQL

[anselme]

Hello

for MS SQL 2000

I want to return the number of days between a date in the database and today

something like

SELECT user.fName,
 user.lName & " (" & (datediff(now - user.lastVisit))  & " )" 
FROM  user

I must return

John Turner (38)

where 38 are the days between last visit and now

thank you