>Hi all,
>
>There are two ways to write "BETWEEN" clauses in a SQL query or view:
>... WHERE dDate BETWEEN ?vp_dBeg AND ?vp_dEnd
>or
>... WHERE BETWEEN( dDate, ?vp_dBeg, ?vp_dEnd)
>
>Is there a performance difference between the two, or is it only a matter of writing style?
>
>José
Jose,
In my tests in a 50000+ recs table first version was slightly faster but the difference was at max 0.023 secs. So the main difference should be where it's used (remote view or regular VFP) I think.
Cetin