You find that all functions can cause this problem.

SELECT *

FROM

WHERE

@SomeVariable = Function(SomeColumn)

Check your execution plan or SET STATISTICS IO ON and look at your read counts.  You will see that...