so you want to maintain some kind of identity. It is possible to do the job on your own or let SQL Server manage this.

Some days ago there was a thread about this, but I can't find it right now.

Of course, can a SQL statement modify the value to what you want, but as you may want this for consecutive numbering or indexing, all numbers should be unique, and that is the problem you have to deal with.

[/quote]

I suggest to take a look at BOL for 'identity columns' as a start.

Maybe it helps when you say what you want this for?

Cheers,