There's no separate setting for ANSI_PADDING in the SQL Server connection string. You can review avalable parameters at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbcsql/od_odbc_d_4x4k.asp.
You can issue SET ANSI_PADDING after you make connection. It'll be in effect until connection is closed. Keep in mind that SET ANSI_PADDING OFF affect char() columns with NULLs also.
>
>Thanks for the help. I really appreciated it. :)
>
>By the way, is there a way on how to set the ANSI_PADDING for every connection object? I connect to my database by executing the SQLStringConnect() function in VFP>
--sb--