Subject Re: Fw: [IBO] Searching for a string into a string
Author Lucas Franzen
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)

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).