No probs.

Thanks for your help anyway.

Hope friday afternoon is a bit better.

I would still need a dynamic query to SELECT * from the base1005 table though wouldn't I?

I am a bit confused.

Thank you very very very much!!

I just thought I would reply to say thanks before I dive into the scary topic of Dynamic SQL.

Thanks for your quick response.  The date part works fine, however I don't know how to write the code so that I can assign the filename as the variable

Thank you very much for your help.  I am going to have a look at BCP and sp+cmdshell today.

Incidentally, I need the files split as I need to send...