>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