Debra

If you don't have more than one update in any particualr second, you could do something like this:

select datediff(s,'01 Jan 1980',getdate())

If your updates are more frequent than that, you could try multiplying by 1000, adding the milliseconds, and casting as bigint.

Good luck

John