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