>>>OK Here's my solution. Thanks to all of you who contributed.
>>>Borislav - I don't see the need for your form of ?m.lcPermID since lcPermID is a local variable and the select is called only once. Perhaps I am missing something.
>>>

>>>lcSQL = "select * " + ;
>>>	"from TRPSurvey" + "..exported " + ;
>>>	"where ltrim(rtrim(PermID)) = " + lcPermID
>>>
>>>IF sqlexec(m.lnHandle,lcSQL,"crsImport") < 0
>>>   AERROR(laError)
>>>   MessageBox(laError[1,2])
>>>ENDIF
>>>

>>
>>How does it work? I do not see lcPermID surrounded by single quote.
>
>It works fine. lcPermID is a variable containing a character string. So its a simple concatenation.

Watch for my upcoming FoxPro Advisor article.