Linda,

SCAN
   \\field1,field2
   \
ENDSCAN

This is what I do even though it looks a little odd, it performs fast and is cleaner than an IF or IIF() construct or adding a chr(13)+chr(10) to the end of the \\ line. I've never had it not output the right data. I've got an app that uses this to put millions of rows of data into BCP files for loading into a reporting database each weekend.

>seems to work. On the first few attempts it cut off the first row but I can't replicate that problem no so I'll consider it solved.