Hello Michael.
What i intend to do is:
When the new row is added the procedure scans a certain numeric column for the next available number (it could be the MAX()+1 or a gap between say 5 and 7). When procedure finds the next available it inserts it into the column as the default value.
TIA.
Kamil.

>If you're using SQL Server 2000, a scalar function can be used in a CHECK constraint. If not, you're stuck using a trigger.
>
>-Mike