Yes, the timestamp data type is misnamed in MS SQL Server. The datetime data type is an equivalent to the SQL-92 timestamp data type. BTW, you could find all this info in the SQL Server Books Online.
>
>I found a description at
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=54&rl=1 "timestamp - A database-wide unique number that gets updated every time a row gets updated". Pretty silly of me to assume a field called row_timestamp that is timestamp datatype would be similar to DB2 timestamps. It looks like someone could use it with a mirror table to find out which rows have been updated since the mirror table was refreshed. I used CAST(... AS INT) in my pass through SQL Query and at least pulled back something readable.
--sb--