Re: Random Unique Integer

I have a table T1.  It contains a field called F1.  Is there a way for me to set the table T1 up such that F1 can be populated with a random integer such that F1 is a unique integer?  I would rather not create a stored procedure.

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu