In general, you should avoid applying a scalar function on a column when comparing against another column, variable or constant. Let's use an example. Frequently, we got cases from customers who are not aware of performance implications and do just that.