MS SQL Server :: String Data, Right Truncation

&&"string Data Right Truncation&&" Hello everyone, I'm using CRecordset in order to write into the SQL Server, i have a problem that everytime i'm trying to write a varchar fields with size X and i put in the CString larger string then X i get CDBExceptio

www.bigresource.com