OzYbOi d(-_-)b (11/23/2011)
Certainly a little curious as to why only the Decimal behaves in this manor... But this is something that I have run across before in a shop where implicit conversions of data was the normal practice. :crazy:
It's not just decimal. Numeric will fail as well. And it's also not just implicit conversions. Explicit will fail as well.
select CONVERT(decimal(18,6),'')
go
select CONVERT(numeric(18,6),'')
go