Article ID: 266681 - View products that this article applies to.
This article was previously published under Q266681
Trailing spaces are not removed from character fields when you use the RTRIM() function in a SQL Select statement passed through the Microsoft Visual FoxPro ODBC Driver.
The Visual FoxPro ODBC Driver maps character fields to an SQL_CHAR type with the same length as the source column or columns.
Steps to Reproduce Behavior
For additional information regarding String Functions supported by the Microsoft Visual FoxPro ODBC Driver, search for "String Functions" in the Microsoft Visual FoxPro ODBC Driver Help Reference.
For additional information regarding ODBC data types and corresponding Visual FoxPro data types, search for "SQLGetTypeInfo" in the Microsoft Visual FoxPro ODBC Driver Help Reference.
For more information regarding how Microsoft FoxPro data types are mapped to ODBC SQL data types using the Microsoft Desktop Database Drivers, search for "Microsoft FoxPro Data Types (Advanced)" in the Microsoft Desktop Database Drivers Help file.
(c) Microsoft Corporation 2000, All Rights Reserved. Contributions by John Desch, Microsoft Corporation.
Article ID: 266681 - Last Review: October 22, 2002 - Revision: 1.0
Contact us for more help
Connect with Answer Desk for expert help.