Automatically assigning incrementing number in SQL

Hello,

Is there a type of sql query I can run that will assign numeric values to all records in a table (a specific field) that starts at 1 and increments up by 1 until the end of the table is reached? Is there an autonumber type of field that will do this?

--
Sincerely,

Sean M. Severson
Project Manager



===============================

"Our aim is to become partners in your
success through our performance."

Technical Assistance Company
807 Forest Avenue
Sheboygan Falls, WI  53085

(920) 467-6711
www.2tacweb.com


===============================