Andrew-495157 (9/7/2012)
Yes - I understand conversion and castingI wonder if you would re-read my previous post? To confirm what is in it.
What is to re-read? The conversion by SQL Server was from nvarchar to int, that's why you got the error.
There is a hierarchy to the datatypes which SQL Server uses when doing implicit conversions. Unfortunately I am having problems with my google-fu in trying to find the appropriate reference in Books Online to provide that information to you.