Hi Jeff,

I couldn't find a way to get this to work, so I used the method described by Will in this post:

http://www.sqlservercentral.com/Forums/Topic450843-23-1.aspx

Jessica

I think I have discovered an answer:

"...OLE DB is based on COM, and thus all the strings are Unicode BSTRs (UTF-16 on Windows 2000, and UCS-2 on all other...

Hi Will,

I am creating a stored procedure that will query a database for some information and then generate a txt file with that information. This is for a medical...

Figured this out myself by opening up the file in MS Word and selecting "Reveal Formatting". The code above does add a carriage return effectively.

-Jessica