Microsoft KB Archive/75103

{| = DOS Operators Work When SQL Operators Are Chosen in Q+E =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q75103

SUMMARY
The &quot;Q+E for Microsoft Excel User's Guide&quot; 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.

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 &quot;B&quot; are listed.