I have a question. I have open text search fields in an application. You can search for anything. It doesn't use collections or anything, it just results in a LIKE statement in a SQL query (with some additional intelligence). Let's say I have the following names in a database field:
Now when the user searches for 're', I want both names to be returned. But since André has a special character, the SQL query only finds Freire.
Hope you can shed some light on this!