The information in this article applies to:
SUMMARYThe ODBC 2.0 Help file, Odbcjet.hlp, incorrectly lists the SUBSTRING() scalar function as a supported function of the Open Database Connectivity (ODBC) drivers shipped in the Microsoft ODBC Desktop Database Drivers Kit, version 2.0. The MID() function replaces the SUBSTRING() function and should be listed instead of SUBSTRING() as a supported scalar function. MORE INFORMATION
The ODBC 1.0 drivers shipped in the Microsoft ODBC Fulfillment Kit use the
SUBSTRING() scalar function to return a specific number of characters from
a text string, starting at a position you specify.
For example, assume we have the text string "Hello World." To return the
"World" string, use the following function:
If you try to use the SUBSTRING() function with an ODBC 2.0 driver, you may
receive the following error message:
REFERENCESFor more information on Scalar functions, click the Index tab in Jet Engine Error Help (open the Odbcjet.hlp Help file in the Windows\System folder), type the following text scalar functionsand then double-click the selected text to go to the "Scalar Functions" topic. Additional query words: 2.00
Keywords : |
Last Reviewed: October 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |