Hugo Kornelis (3/5/2016)
I wonder why int to varchar was special.
I am sure that sometime, somewhere deep in the dark and muddy past of SQL Server (probably back in the Sybase days), someone had a compelling argument for this.
I am not going to speculate on this one, though!
I think the "blame" for this is on Microsoft.
When I try the following in Sybase (Adaptive Server Enterprise 15.7), I get an error:
SELECT CONVERT(VARCHAR(1), 234523)
ERROR: Insufficient result space for explicit conversion of INT
value '234523' to a VARCHAR field.