Microsoft KB Archive/46797: Difference between revisions
From BetaArchive Wiki
m (Text replacement - "<" to "<") |
m (Text replacement - "&" to "&") |
||
Line 11: | Line 11: | ||
To search on an alphabetical range in the Works Database, use the following query: | To search on an alphabetical range in the Works Database, use the following query: | ||
<blockquote>=“B”& | <blockquote>=“B”&<“C” | ||
</blockquote> | </blockquote> | ||
Please note that B is the start of the range and C is the last letter in the range, but is not included in the range. This particular query hides all records except those having a B as the first character. | Please note that B is the start of the range and C is the last letter in the range, but is not included in the range. This particular query hides all records except those having a B as the first character. |
Revision as of 14:20, 21 July 2020
Works: Method to Query on an Alphabetical Range
PSS ID Number: Q46797 Article last modified on 06-12-1996
1.00 1.05 2.00
MS-DOS
SUMMARY
To search on an alphabetical range in the Works Database, use the following query:
=“B”&<“C”
Please note that B is the start of the range and C is the last letter in the range, but is not included in the range. This particular query hides all records except those having a B as the first character.
KBCategory: kbother KBSubcategory: dworkskb Additional reference words:
============================================================================= Copyright Microsoft Corporation 1996.