Re: Can LIKE use indexes or not?

John Sidney-Woollett said:
> select * from t where new_upper_f like upper('MMM%');

I think I meant

select * from t where new_upper_f like 'MMM%';

or

select * from t where new_upper_f like upper('mmm%');

John