>>>For an SQL select string it is 8192.
>>
>>Note that this is the "compiled" length not the text length. I remembered that much -- I forget how to get the compiled length.
>>
>So this is only for the vfp data engine ?
>Any limits to SPT or the stuff sent by cursoradapter to various backends ?
>Or is there a limit in the ODBC / OleDB driver ?

I don't know for sure. I have a vague memory from over 10 years ago when we broke a huge query into a master view working against other views that the limit was the same. I wouldn't place a wager on that, however,

Hank