Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BETWEEN or BETWEEN?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00132234
Message ID:
00132260
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform