Selecting multiple rows to output text

[jimoo]

I have a db with a one to many relationship. I want to extract the records of the child table to text. They are basically user comments. Each record is a different comment. I plan to archive these comment in another format.

Can anyone provide a solution to select all the records, and in addition place a new line and maybe a seperator.



Example: (Assume field is comment)

Select table.comment +CHAR(13)+CHAR(10) + '---------' from table

Again, I need the output to text (or excel.

Thanks in advance.



Jim