Index by words seems broken in 2.5.3

[Ivan Smahin]

Hello Ruslan,

Monday, January 15, 2007, 1:33:36 PM, you wrote:

> On 15/1/07 1:07 PM, "Pierre Rossel" <agora07 ÎÁ 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'
>  

Just misprinting.
WHERE LEFT(fld, 5) = 'abcde'


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com