Hi George,

Thanks for the clarification.

Gaps in the account numbers will not be a problem.

In short, all I am trying to do is generate a unique account number for...

Hi George,

Thanks for your reply.

There will not be a heavy volume of new accounts. But in any case, I was not sure what you meant by

".. You run the...

Hi Michael,

I'm not familiar with an

"..do an UPDATE with an OUTPUT clause"

Can you provide a simple example?

Thanks again,

hefterr

Not sure how the session is defined from a Web program (using Coldfusion).

Just wasn't sure what is the definision of the "session".