saving a select stament to a txt file

From: msnews.microsoft.com (yanive_at_nice.com)
Date: 07/27/04


Date: Tue, 27 Jul 2004 19:20:58 +0300

Hi,

How do I export /save the result of a select statment to a text file?

Thanks,
Yaniv