Write table columns to an external data file

How would I write the result of a select to an external data file?

something like this

select name, address_1, address_2, city, state, amt from customer

"to an external ouput file"

Thanks in advance Received on Tue Jul 24 2001 - 16:07:04 CDT