SQL Server and auto conversions? [duplicate]

Question

Possible Duplicate:
Is there a way to turn off implicit type conversion in SQL Server?

With all the respect to SQL Server - which is trying to "help" me by auto conversions :

How can I make commands like these to fail ? :

SELECT 1+1+'2'   --4
SELECT '2'+1+1   --4
SELECT 1+'2'+1   --4

Answer 1

You can't, although it's requested feature. The problem was already discussed on SO: Is there a way to turn off implicit type conversion in SQL Server?