OK!  I've made some progress...

Couple of questions.  How do I reset the counter back to 1?  Is there a max limit to the number that this field can go...

Thanks.  The script will probably work with SQL Server 2000, but I need to test it with SQL Server 7.0 in the office.  I don't think scope_identity can be used in...

So, if you populated the table once, you would be able to retrieve and increment each time you accessed it.  Is that correct?

Thanks.

Craig

I tried your suggestion and the ID_COL field is blank!  At what point would this field have a value in it? 

Thanks for your help!

Craig K.