WTF! Works as documented?
When converting character or binary expressions (char, nchar, nvarchar, varchar, binary, or varbinary) to an expression of a different data type, data can be truncated, only partially displayed, or an error is returned because the result is too short to display. Conversions to char, varchar, nchar, nvarchar, binary, and varbinary are truncated, except for the conversions shown in this table.
From data type | To data type | Result |
---|---|---|
int, smallint, or tinyint | char | * |
varchar | * | |
nchar | E | |
nvarchar | E | |
money, smallmoney, numeric, decimal, float, or real | char | E |
varchar | E | |
nchar | E | |
nvarchar | E |