General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL server padding a 10 character field with spaces
I created a view which is based on ODBC setting for an SQL server table. IF VFP when I set a 10 character field a value
of "ABC" in a new record, after I update the SQL table, the field is saved to the SQL server
table as "ABC" padded to the right with 7 spaces. Is there any way either through a VFP command or ODBC setting
or possibly an SQL server setting to prevent this from happening ?
Thanks for your help
Stephen J. Hunt
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only