Alvin

>I have a column in SQL Server table and would like to calulate
the differences in day/secs in 2 of the rows/records.
What command shall I use to get the difference from 2 DateTime
fields. Thanks.

Try the datediff function (from the query analyser type in datediff and press SHIFT-F1) for the help. This allows you to compare differences between parts of dates.

Cheers
Steve Lea