>>>>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.

Still we are responsible for database design. It means integer (or at least fixed-length char) primary/foreign keys.