>>The database is VFP.
>>
>>1. SELECT expression that returns inconsistently:
>>lcStrSQL = " SELECT p.* FROM arperend p " + ;
>> " WHERE p.pedPerEnd = {" + DTOC(ldPeriodEnd) + "} "
>
>How about something like:
>
>ldDate = '1991-10-01' && get the date string in this format
>cSql = 'select p.* from arperend p where p.pedPerEnd = {^' + ldDate + '}'

The "Strict date" in TOOLs/OPtions/General is set to "OFF".
Queries return incorrect result randomly for 1 or 2 records from about 700 records.
However, the date expression is included in WHERE-clause of almost all queries.
I'm going to try the proposed date format.

Thank you.
Ed