Updating the column with: 5 + (rnd(1) * 145) should give you a random number between 5 and 150
Ben Greenberg GIS Coordinator NAI MLG Commercial 262-797-9400 -----Original Message----- From: Morrier, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, June 10, 2004 1:34 PM To: [EMAIL PROTECTED] Subject: MI-L Random Number Ranges.... Hi All, Is there a way to update a column with random numbers that fall within a certain range? I would like to update 500+ records with a value between 5 and 150. Is this possible? TIA Steve --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12133
