>>>Yes that's right, default is OFF. I wasn't clear. Combo doesn't do the trimming so it should be saved with OFF.
>>
>>No, default for the SQL Server ODBC driver and Microsoft OLE DB Provider for SQL Server is ON.
>
>OK,OK it should be friday:)
>Cetin

Cetin,
pratically,
to use SET ANSI_PADDING OFF is a suicide.