DOS Operators Work When SQL Operators Are Chosen in Q+E

 Last reviewed: November 2, 1994
Article ID: Q75103

SUMMARY

The "Q+E for Microsoft Excel User's Guide" states that you may use either the DOS comparison operators or the SQL operators. You specify what you want to use by choosing Options from the Layout menu.

However, the Like operator works with either set of wildcard characters, even if the opposite choice has been enabled.

Microsoft is researching this problem and will post new information here as it becomes available. This behavior does not occur with Q+E for OS/2.

MORE INFORMATION

MS-DOS Matching

*       Zero or more characters
?       Any single character

SQL Matching

%       Zeror or more characters
_       Any single character

Steps to Reproduce Problem

  1. From the File menu, choose Open and select EMP.DBF from the QE subdirectory.

  2. From the Layout menu, choose Options.

  3. Under the Like section, select the SQL(%,_) option button and press ENTER.

  4. Select the EMP_ID column.

  5. From the Select menu, choose Add Condition.

  6. Select Like as the Operator option.

  7. Enter B% for Value and press Enter.

Result: Two records with last names that begin with the letter "B" are listed.

REFERENCES

"Q+E for Microsoft Excel User's Guide," pages 14-15.

KBCategory: kbother
KBSubcategory:

Additional reference words: noupd

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.