>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?

AFAIK, the only difference is that the first notation is SQL standard, while the second is "Fox only". Something similar occurs with the LIKE option, which also has Fox equivalents.