given:

lnresult=sqlexec(lnhandle,lcsqlcmd,'curresult')

what is the maximum number of characters for the lcsqlcmd?

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