>SName is defined as nvarchar(100)
>
It is now what I am asking. Please post DDL for both tables. Also, as Boris said, explicitly specify all fields in the INSERT command, e.g.
INSERT INTO StudentLookup(SCN, SName, TCN, TName, ChgDate)
SELECT ....
>>>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
If it's not broken, fix it until it is.
My Blog