Use the ROWID keyword: Update MYTABLE Set MYCOLUMN = ROWID
or increasing 10 : Update MYTABLE Set MYCOLUMN = (ROWID *10) Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk -----Original Message----- From: Reno Lindberg [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 3:59 AM To: [EMAIL PROTECTED] Subject: MI-L Auto-increement of row number in table Hello all I would like to update my column with a number that increase with 1 or 10 for each row. How can I do that? Best wishes Reno lindberg --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12054
