Index by words seems broken in 2.5.3

[Pierre Rossel]

> -----Original Message-----
> From: Ruslan Zasukhin
> Sent: Monday, January 15, 2007 12:34 PM
> 
> 
> On 15/1/07 1:07 PM, "Pierre Rossel" <agora07 at prossel.com> wrote:
> 
> > 
> > select ** from MediaItem where mediaData like 'b%'
> 
> It looks you want search START WITH.
> 
> The best way for this to use
> 
>     WHERE fld(left, 5) = 'abcde'

Yes, it works with:

  WHERE LEFT(fld, 5) = 'abcde'

But what happened to the like syntax ?

With the like syntax, by default I can search words that start with
something, but I just have to add a % in front of the searched word to be
able to find it in the middle of words as well.

With the left syntax, I cannot do this anymore.

So, it is only a bug in the like operator ? Will you fix it ?

Thank you 
Pierre Rossel