help - spool file name - use variable

 Hello:

I'm trying to spool out couple of files from my temp table. Part of the file name is coming from a variable from the temp table. I use: spool C:\CYCLE_COUNT_$temp_variable.DAT but it's only one physical name instead of using the variable. How can I code the variable name as part of (spool) file name? Thanks
 Do You Yahoo!?

Yahoo! Auctions - buy the things you want at great prices Received on Mon Apr 23 2001 - 14:40:46 CDT