Tiago Teixeira Barrionuevo schrieb:

>
> Then you can use LIKE:
>
> WHERE MyStringField LIKE '%stre%'
>
> or
>
> WHERE MyStringField LIKE '%STRe%'

no, you can't since LIKE *IS* case sensitive.
In case of searching with LIKE '%STRe%'you won't find any entry like
"Street", "STREET", etc.
You would have got to do an UPPER compare again (WHERE UPPER (FIELD)
LIKE '%STRE%'.

Give it a try and you'll find out that it is much slower than using
containing (which is very fast even when searching within text BLOBS).

Luc.