>>>This is what I have been doing (since I posted my message). The issue (could be but hopefully not) is that the query string will be longer than is allowed. My query string (to include both sets) will have the WHERE FIELD IN (.) and the IN expression could be long. Theoretically. Thank you.
>>>
>>If you set the SelectCMD in code, the length of the expression does not matter. Although it may be better to not hardcode long lists and have them in the separate table.
>
>I do set the value of SelectCMD in code. So you are saying that if the length of this expression is even 1000 characters it will work? If so, this is very good. Thank you.
>
>P.S. Keep in mind that even though I set the value in code, it is data driven so it is not per se "hard-coded"

Hi Dmitry,

The limit is 8190 characters for any command, and it is possible to create select statements that surpass that limit and then will not work (I learned this the hard way :)) (I thought the past of learn is learnt? spell checker does not like it though)

Easy way to test is this:

lcCmd		= REPLICATE('*', 8190)
EXECSCRIPT(lcCmd) && Works

lcCmd		= REPLICATE('*', 8191)
EXECSCRIPT(lcCmd) && Line too long error