I don't understand your question...when you pull the data from the text file, does the data already have the CR/LF in it for that field? If so, you don't need to add it. If it doesn't, how will you know where you want to insert the CR/LF?

>How can i pass chr(13)+chr(10) programmatically before i execute my query.
>
>the data i get from the text file.
>
>I read the text file and assign the data of the text file to a varible and then i fire the query.