Microsoft KB Archive/124501

{|
 * width="100%"|

"Ends With" Operator Won't Work with Some ODBC Drivers

 * }

-

The information in this article applies to:


 * Microsoft Query for Windows, version 1.0

-

SYMPTOMS
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.

CAUSE
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

RESOLUTION
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"

STATUS
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.

MORE INFORMATION
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.

Additional query words: ending last condition

Keywords : xlquery

Version : 1.00

Platform : WINDOWS

Issue type :

Technology :