• The essence of this question is in the following:

    SELECT CONVERT(NVARCHAR(2),0) -- returns 0

    SELECT CONVERT(INT,N'') -- returns 0

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins