Ryan,
>I have been asked to take the data in a table and turn it into an ASCII comma delimited text file. Does anyone know how this can be done?
USE mytable
COPY TO myfile TYPE DELIMITED
This creates myfile.txt, which is comma-delimited. You can specify the file extension if you want, but otherwise it defaults to .txt. If you need less than the entire file, you can set a filter before the COPY, or add a FOR clause on the COPY command.