Hi all,

Using SugarCE 5.2.0d.
We're using the Description field in the Contacts module to hold a lot of legacy free-text data from our contacts database.
We need to be able to search on this data. I added a 'Description' field to the Basic Search tab, using the Studio.
However, if I put a word in this box, it only matches records where the description field begins with that record. For instance, 'painter' would match 'painter of houses', but not 'house painter'.

I noticed that the right behaviour happens if I put a percentage sign in front of the search: '%painter'. This makes it seem like the query is being fed directly to SQL using the LIKE clause. Is it possible to automatically add this to any query?

If it's not possible using the interface, could I modify the source to make this change? Which files would I be looking at?

Cheers,
David