Thanks tb, but that wasnt what I was looking for. I'm mostly try to figure out a query.
e.g.
Insert into Table (RowNum)
select max (RowNum) from Table;
Something to this effect (syntax may not be correct, but u get the picture).
Only I need a system where a number is returned back to a calling ASP page (its an invoice number, explains why its cannot be a GUID)
I has to be unique and should not be generated again. Time stamp is usually best in this case, but i'm looking for options.
Thanks.