How to manage a set of unique numbers...

Hello. I'm wondering how people manage sets of numbers. For example, lets say you had a system where you were handing out telephone numbers and extensions to users. How do you quickly assign a new telephone number and extension to someone? Do you populate a table with all the free numbers and extensions and select/delete a row from there to hand it out, and have a trigger that returns it to the free list on delete?

thanks, roland Received on Fri Feb 12 1999 - 19:51:25 CST