>I see. May I ask what's the value of cTableFox2x?
>

cTableFox2x = 'Tempcrystal' and cTableToPrint = 'Crystl3731'

When cvcondit = ' .T. ' , the request is just ...

>>>Why the '/' ?

>>
>>
>>Because /20/  <>   /200/  <>  /2000/
>>
>>>cvcondit = " !TempCrystal.ltransfert and  ALLTRIM( TRANSFORM( TempCrystal.telephid ) )  $ oPrivatecParamCR.Condit "

>>>
>>>>Hi all,
>>>>
>>>>I have a problem with the syntax for a sql command.
>>>>
>>>>

>>>>oPrivatecParamCR.Condit = "/20/26/38/39/40/42/51/70/1071/1450/1707/1936/"
>>>>
>>>>cvcondit = " TempCrystal.ltransfert = .F. and '/' +     ALLTRIM( TRANSFORM( TempCrystal.telephid ) ) + '/' $ oPrivatecParamCR.Condit "
>>>>
>>>>
>>>>SELECT * FROM ( cTableFox2x ) INTO TABLE ( cTableToPrint  ) ;
>>>>  WHERE &cvcondit
>>>>
>>>>

>>>>
>>>>This command give me no result and it is not true !
>>>>I think that the reason is perhaps the & ?
>>>>
>>>>How can i have a just result ?
>>>>
>>>>Thank in advance for help.
>>>>
>>>>Bernhart