If you want a sequential number, add a new column to your table w/ Integer value, then use Update Column to update this new column and type in 'rowid' into the value field. _Renee Rene� Gerasimtchouk Geographic Systems Specialist II Planning Department, rm. 400 (408)277-2294
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:34 AM To: [EMAIL PROTECTED] Subject: MI-L Auto Increment Hey, I am looking for an easy way to auto increment a column in my table. I would like to populate a column to use as a primary key. Is there an SQL statement I could use to update my table with this data? Thanks, Jerry Bratton ole0.bmp (501) 905-8556 fax (501) 690-5741 cell (501) 905-5741 desk
