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”&amp;<“C”
<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.