SName is defined as nvarchar(100)



>>Here's the SQL
>>

>>insert into StudentLookup 
>>  Select SCN, Sname = (SLastName + ', ' + SFirstName), TCN, TName, chngdate = getdate()  from qryICECLExport
>>

>>
>>The error I'm getting is:
>>
>>Msg 8152, Level 16, State 4, Line 1
>>String or binary data would be truncated.
>>The statement has been terminated.
>>
>>I thought perhaps the SName field wasn't long enough, so I expanded it (still in development phase of project), but I'm still getting the error.
>>
>You need to look at every field in the StudentLookup table and compare with the resulting structure of your Export table.
>
>You may find this blog post helpful to find maximum length of value of every field:
>
>http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/maximum-length-of-data-in