To clarify, by 'contrary ascii code', I meant not respecting the ASCII binary values, which is demonstrated by my code snippet so does yours. Thanks for the confirmation!

Thanks very much!

Thanks GSquared,

Timestamp field will be around, right?

create table Test (

ID int identity primary key,

rowversion Timestamp, -- Is this how it should be used in...

Thanks GSquared!

The document talks about "timestamp syntax for rowversion data type" being deprecated. Can you enlighten me as to what timestamp syntax is?

Thanks Steve, K. for the comments/suggestions.

Is there any danger of of varchar or char data type being dropped in future releases of MSSQL as image, ntext and text types are?

Thanks Jo for link as well as list. Truely appreciate it!

Joe,

Thanks for the reply!

Is there any article anywhere that warns about pitfalls that are not documented in books online?

Or a best practice in SQL database programing?