>>>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.
>
>What about ltrim(rtrim construction? If I would be a sql-server programmer (on primary basis, i mean) then i could kill someone.

:-)
Agree, but I think that comes from our front end - VFP.
Till VFP9 there was no varchar types and when you design SQL Server database you design it as you used to in VFP - CHAR, Numeric, Date (OOOOPS no Date type, what I must do now?????) etc.