Hey Thomas!

> is the following a known limitation, as designed or a bug?
>
> * The following queries uses an UPPER index on NAME:
>
> select * from accommodation where upper(name) like 'ARC%'
> select * from accommodation where upper(name) starting with 'ARC'
> select * from accommodation where upper(name) starting with

upper('arc')

>
>
> *But the following does not:
>
> select * from accommodation where upper(name) like upper('arc%')
> select * from accommodation where upper(name) like upper('arc')

The issue is not with the expression index.

This is a known limitation of the *LIKE operator*.

{though I'm not sure this particular twist has been logged in the
tracker}

I tried the same statements with a "standard" index and they exhibited
the same modes.


Sean