> you don't need an auxilary table to do this.
> You can write a small SP to do suspend used (or unused) numbers via
> cursor(plus counter) loop. This will be more economic.

Not always. When doing JOINs for example, this won't be
a join with an indexed table, but with a resultset (from the
procedure) that's being generated "on the fly". This could get
slowish.

> You know,
> To be a Firebirder means of to be speedy-homoeconomicus-gonzales.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com