Andy Brownsword changes things around:
Implicit conversion happens in SQL Server when the engine detects a mismatch in data types and automatically converts from one type to another. This can be helpful as it makes different types interchangeable and is generally transparent to the client, but it can come with issues.
Usually the downside from implicit conversion is seen through performance impact. But we’ve got something a little different today – an inconsistent result set.
Read on for Andy’s example.