When you do a SELECT... statement, where does the temporary table (name.tmp) get created (which is deleted at the end of the process) and can that location be changed?
Michael Meinberg
Tamtech, Inc
"The amount of things that I know nothing about is alarmingly increasing."