hey everyone,
is there a way to look at the last row in a table. what i am trying to do is add on to sequence numbers in a table. i want to look at a table's field, for this example we will call it seqnum, and say something like seqnum + 1 for every new insert i make into the table. this way i keep the numbers in sequential order. any advise would be appreciated. thanks.