Hi Barry,

Use the STRTOFILE function to build the sql statement AND FILETOSTR Function to pass the statement to SQL. FoxPro limitations is 255 characters in the pass through statement. This has been the easiest way I have found around this problem.

SQLEXEC(ch,FILETOSTR(tempfile),'sqlresult')

HTH
John



>I'm defining an admittedly rather long sql expressiong which is stored to a memvar that, when evaluated, seems work ok in VFP but when passed to sql server via sql pass through, appears to get truncated.
>
>Is there any light in my darkness out there
>
>"Ignorance is as Ignorance does"