+1

Using a function on both sides of the equality negate any index usage on that column. Upper(@a) is OK by itself, but = upper(indexed_column) results in a table scan. No...