You typically won't hard-code values like that; they will be in variables or objects.

lcTest = "this is my" + chr(13)+chr(10) + ;
         "first test"
Insert into ocrdata(id,tiffile,ocdata,created_dt)  Values(4333,'demdemorecv10',lcTest,{9/7/2004})

If you really want to hard-code it:

Insert into ocrdata(id,tiffile,ocdata,created_dt)  Values(4333,'demdemorecv10','this is my' + ;
     'first test',{9/7/2004})

or if you want carriage return in data:

Insert into ocrdata(id,tiffile,ocdata,created_dt)  Values(4333,'demdemorecv10','this is my' + ;
     chr(13)+chr(10)+'first test',{9/7/2004})

>I have an insert query.
>When my ocrdata field has the data in two lines:
>'this is my
>first test'
>i am getting an error saying : Command contains unrecognized phrase/keyword.
>If the same data is in 1 line: 'this is my first test'
>that works perfect.
>How can i adjust my data when executing the query.
>
>*********Query************************
>the following fails:
>Insert into ocrdata(id,tiffile,ocdata,created_dt) Values(4333,'demdemorecv10','this is my
>first test',{9/7/2004})
>
>the following works fine:
>Insert into ocrdata(id,tiffile,ocdata,created_dt) Values(4333,'demdemorecv10','this is my first test',{9/7/2004})
>**************************************
>
>I am trying to use the above query via VB to foxpro.
>Please Help.
>
>Thank you very much.