Generate file from sql

Hi,

I have a table with some data in my sql database. I want to print the result of that table in to a file in my system from sql . I found some ways to print text from sql to a text  format file. My requirement is to send the sql command output into a text file.Please suggest a way to  solve my problem.