What happens when implicit type conversion (coercion) occurs in a WHERE clause predicate?

Question

SQL Fundamentals — Hard

What happens when implicit type conversion (coercion) occurs in a WHERE clause predicate?

Accepted Answer

When implicit type conversion occurs in a WHERE clause predicate, the engine may cast the column rather than the literal, leading to a full table scan instead of using indexes efficiently.