Microsoft KB Archive/28541

Specifying OR (|) Criteria in Database Query

PSS ID Number: Q28541 Article last modified on 06-12-1996

1.0

MS-DOS

Summary: Page 3 of 3 in the Database Query Help Menu gives the following syntax as an example for using the OR operator:

=&quot;Smith&quot;|&quot;Smyth&quot; This example is incorrect. The correct syntax is as follows:

==&quot;Smith&quot;|=&quot;Smyth&quot; This query will list any record that contains “Smith” or “Smyth”. Page 411 of the “Microsoft Works Reference Manual” also gives the correct syntax for this command.

KBCategory: kbother kbdocerr KBSubcategory: dworkskb

=
================================================================ Copyright Microsoft Corporation 1996.