Vladan, Paramind,

Thanks so much for your inputs and ideas! I went ahead and used the idea that Vladan introduced and selected the MAX(SEQ_NUM) from the target table. In addition I...

Vladan,

You are correct in everything except that I need to get a numeric back. Not an integer.

> paramind,

Yes, the value should be unique.

Thanks again.

David

Thanks for the replies.

Here's a shot at trying to explain in furhter detail. If we disregard the rest of the stuff I'm trying to do here's what I want from the...