>>Hello Fabio
>>
>>Thanks for your pointers! ja, my sql command was way too long {gr} - it was 15114 cahracters long just for the filter clause.
>>
>>thanks again for your help!
>>
>>>>Hello everybody.
>>>>
>>>>does anyone know what the limitation for the character length of the WHERE string in the local SQL command is (VFP 6, SP 5)?
>>>>
>>>>thanks in advance for your help!
>>>
>>>2 LIMITS:
>>>

>>>1. LEN("SELECT SQL COMMAND")<=8192
>>>2. SYS(3055) - FOR and WHERE Clause Complexity
>>>

>
>Macro ?
>Put the literal strings into variables.

jes, but how exactly do you mean?

a simplyfied example of my situation looks like this:

cWhereStr = "Inlist('12345', 'test', 'hallo', ...)

select ;
   fld1, ;
   fld2, ;
   ... ;
   from table1 q_a, table q_b ;
   where &cWhereStr ;
   group ... ;
   into...

there are some fields which are variable though macros, as well as the goup clause and the from clause.