> > The initial tests gave me negative on this. (by the way wouldn't
> > that be useful? it could help browsing the blobs also)
>
> Yes, I think it's useful.

It's good they're planned for 2.0

>
> > The other solution is to create another filed that is computed as
> > substring of the first and index this one.
>
> You cannot index COMPUTED BY fields, as they aren't stored.
>
> The one thing you can do, is create a second column and create
> triggers to update it. Index that column.

That's exactly what I ended up with.

>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server
> Upscene Productions
> http://www.upscene.com

Thanks for ansewer,
CUIN Kaczy