Roy,

<< How long do they last for? Are they available between sessions/processes
or what? >>

No, they just last as long as the temporary table for which they were
created.

--
Tim Young
Elevate Software
www.elevatesoft.com