Hi Jeff,

YES you are right ,can you give me clear idea about carriage return format . that would be appreciable

Hi james ,

so i can create view like this on table and then bcp out to txt file .

hi ,

Thanks for your reply ,i will try this