If the index is being bypassed, then the RHS of the comparison should be type-cast.

If you assume that there is an index on COL1 in the above example, if COL1 is type-cast instead of the RHS, then the index will be bypassed and the query will perform a full table scan.

Use with weak typed variables to cast them as another type.