ID: Q124501
1.00 WINDOWS kbtool xlquery
The information in this article applies to:
When you use the 'ends with' or 'like' operators in Microsoft Query, your query may not return any records to the Microsoft Query data pane.
This problem may occur you are using one of the following Open Database Connectivity (ODBC) 1.0 drivers:
Microsoft Access 1.0, 1.1
Btrieve 5.1
dBASE III, IV
FoxPro 2.0, 2.5
Paradox 3.0, 3.5
Text
To correct this problem, use the version 2.0 ODBC drivers for Windows.
To obtain these drivers, call the Microsoft Order Desk at (800) 360-7561 and request the version 2.0 ODBC drivers for Windows. If you are outside the United States, contact the Microsoft subsidiary for your area. To locate your subsidiary, see the Microsoft World Wide Offices Web site at:
http://www.microsoft.com/worldwide/default.htm
Microsoft has confirmed this to be a problem in the Microsoft ODBC drivers, version 1.0 for Windows. This problem has been corrected in the drivers shipped with the Microsoft ODBC Desktop Database Drivers kit, version 2.0 for Windows.
The 'ends with' and 'like' operators allow you to retrieve records that contain a field that ends with a particular string. For example, to see all records that end with the word "Street" in the Address field of the Employee table, you could specify the following criteria in the Criteria Pane in Microsoft Query:
Criteria Field: Address
Value: Like '%Street'
You can also select the 'ends with' operator from the Operator field in the
Add Criteria dialog box. To display this dialog box select the Add Criteria
command from the Criteria menu.
KBCategory: kbtool KBSubcategory: xlquery
Additional reference words: 1.00 ending last condition
Keywords : xlquery
Version : 1.00
Platform : WINDOWS
Last Reviewed: April 6, 1997