Thanks!

Thats way more than I need. Looks like it won't be a problem.

>>given:
>>
>>lnresult=sqlexec(lnhandle,lcsqlcmd,'curresult')
>>
>>what is the maximum number of characters for the lcsqlcmd?
>>
>
>16M is sure. more is possible.
>
>>I writing a data driven routine to build up a where clause, the clause might be very long depending on how I implement it. I want to make sure that it will work.. before I code it.
>>
>>

>>e.g. instead of
>>where dinvoice GREATER THAN OR EQUAL TO '2006-01-01' and dinvoice LESS THAN OR EQUAL TO '2006-12-31'
>>
>>I will need
>>dinvoice GT OR = 2 '2006-01-01' and dinvoice  GT OR = 2 '2006-01-31'
>>or
>>dinvoice  GT OR = 2 '2006-02-01' and dinvoice  LT OR = 2 '2006-02-28'
>>

>>etc.
>>
>>repeated multiple times for multiple conditions like this
>>
>>what is this limit for sql server, and what is it for vfp?
>>
>>PS - COULDN'T USE REGULARE GREATER THAN OR EQUAL TO SIGNS? GOT error message about using a tag or something
>>
>>Thanks,
>>David Schlesinger