>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é
Hi Jose,
I believe that the former is standard SQL syntax. This may be an issue if there's ever any intention to upsizing the data source.
George
Ubi caritas et amor, deus ibi est