{"id":25918,"date":"2022-02-13T21:01:23","date_gmt":"2022-02-13T14:01:23","guid":{"rendered":"https:\/\/tom.ji42.com\/?p=25918"},"modified":"2022-02-13T21:01:23","modified_gmt":"2022-02-13T14:01:23","slug":"between-function-vfox","status":"publish","type":"post","link":"https:\/\/tom.tomwork.net\/?p=25918","title":{"rendered":"BETWEEN( ) Function – VFOX"},"content":{"rendered":"
\n\n\n\n\n\n
Visual FoxPro 9.0 Language Reference<\/span><\/td>\n<\/tr>\n
BETWEEN( ) Function<\/span><\/td>\n<\/tr>\n
See Also\u00a0<\/a>\u0412\u00a0\u00a0Example<\/a>\u0412<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n
\n
<\/div>\n

Determines whether the value of an expression is inclusively between the values of two expressions of the same type.<\/p>\n

\n
\n\n\n\n\n
<\/th>\n<\/tr>\n
\n
BETWEEN(eTestValue<\/i>, eLowValue<\/i>, eHighValue<\/i>)<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
<\/p>\n
Parameters<\/h4>\n
\n
eTestValue<\/i><\/dt>\n<\/dl>\n
\n
Specifies an expression to evaluate.<\/dd>\n<\/dl>\n
\n
eLowValue<\/i><\/dt>\n<\/dl>\n
\n
Specifies the lower value in the range.<\/dd>\n<\/dl>\n
\n
eHighValue<\/i><\/dt>\n<\/dl>\n
\n
Specifies the upper value in the range.<\/dd>\n<\/dl>\n<\/div>\n
Return Value<\/span><\/h1>\n
\n
Logical or null.\u00a0BETWEEN(\u0412\u00a0)<\/b>\u00a0returns True (.T.) if the value of the specified expression is equal to one of the values or greater than the lower value and less than the higher value of the two expressions. Otherwise,\u00a0BETWEEN(\u0412\u00a0)<\/b>\u00a0returns False (.F.).\u00a0BETWEEN(\u0412\u00a0)<\/b>\u00a0returns a null value if\u00a0eLowValue<\/i>\u00a0or\u00a0eHighValue<\/i>\u00a0is a null value.<\/p>\n<\/div>\n
Example<\/span><\/h1>\n
\n
The following example scans the\u00a0orders<\/code>\u00a0table for all records in the\u00a0order_amt<\/code>\u00a0field with values between 950 and 1000 inclusive and displays the\u00a0cust_id<\/code>\u00a0field and the\u00a0order_amt<\/code>\u00a0field.<\/p>\n
\n\n\n\n\n
\u0412<\/th>\nCopy Code<\/span><\/th>\n<\/tr>\n
\n
CLOSE DATABASES\r\nOPEN DATABASE (HOME(2) + 'Data\\testdata')\r\nUSE orders  && Open order table\r\n\r\nCLEAR\r\nSCAN FOR BETWEEN(order_amt,950,1000)\r\n   ? cust_id, order_amt\r\nENDSCAN<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
See Also<\/span><\/h1>\n
\n
Other Resources<\/h4>\n
MAX(\u0412\u00a0) Function<\/a>
\nMIN( ) Function<\/a>
\nFunctions<\/a>
\nLanguage Reference<\/a><\/p>\n<\/div>\n<\/div>\n
Send\u00a0comments<\/a>\u00a0about this topic to Microsoft. \u0412\u00a9 Microsoft Corporation. All rights reserved.<\/div>\n<\/div>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Visual FoxPro 9.0 Language Reference BETWEEN( ) Function See Also\u00a0\u0412\u00a0\u00a0Example\u0412 Determines whether the value of an expression is inclusively between the values of two expressions of the same type. BETWEEN(eTestValue, eLowValue, eHighValue)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[13],"tags":[],"class_list":["post-25918","post","type-post","status-publish","format-standard","hentry","category-13"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6cOVM-6K2","_links":{"self":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/25918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=25918"}],"version-history":[{"count":1,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/25918\/revisions"}],"predecessor-version":[{"id":25919,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/25918\/revisions\/25919"}],"wp:attachment":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=25918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=25918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=25918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}