>Has has anyone ever run into this problem? Is there a simple solution to prevent VIEWS from "padding" the text data that is sent to either Access or SQL database tables?
>
>I'm using VFP 7.0a, Access 97, SQL 7.0 and the latest ODBC & MDAC.
>
>Thanks,
Robert,
I don't know about Access but with SQL Server you can deselect the "Use ANSI nulls, paddings and warnings" checkbox in the setup wizard. Unchecking this will make the ODBC driver trim trailing blanks during the send process.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao