Yes, you can use

declare @Result varchar(8000)

set @Result = ''

select @Result = @Result + coalesce(Field1,'') from myTable
select @Result -- assuming that there are not that many records to fit to 8000 characters limit.

For BCP approach you may want to take a look at this blog
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/how-to-script-all-stored-procedures-in-a

>Hi All,
>
> i Have a table with a single field in SQL2000 and i want it to save into text file in continues format.
>Ex.
>Table1
>Field1
>rec1
>rec2
>rec3
>rec4
>rec5
>...
>
>is't possible to copy all the records in table1 to text file(Text1.txt) and the text file should look like this
>
>rec1rec2rec3rec4rec5...
>
>Thanks.
>ryan