Dumping Select statement output onto a text file

[Mulley, Nikhil]

Hi List,
 
How do I dump the data from console to the text file from the output generated by 
SELECT statement ?
 
 
Thanks,
Nikhil.