Microsoft KB Archive/46797: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
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;&lt;“C”
<blockquote>=“B”&amp;<“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 09:34, 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.