String or binary data would be truncated. The statement has been terminated.

Very often you will get errors like "String or binary data would be truncated. The statement has been terminated". We just wandered why we encountered by this error while everything seems right.But this error simply says you are updating the column with larger size than what it can accommodate.So don't worry just check your field length or your entry for spaces.