Loose search

[Ralf Sander]

Hi list,

I am trying to create a very loose search like the one in the Finder:

1. "do" will find "document 23" or "my Doc" or "todo"
2. but "image 34" fill find "iMage 34" and not "34 image"

How can this be done in valentiva?

using index by words as fieldoption and "=" as operator does only find 
whole words
using "LIKE" is not indexed and hence to slow for me.
using "LOCATE" would be the right function, but it seems not to be 
implemented in 1.0 and it is case sensitiv.

Any hints?

Thanks,
Ralf