While trying to look for orders in the backend and using the search function on the sales order grid i noticed that the search function can only find an order when searching for the full field. for example, if you want to find order "0000000123" and you search for "123" the order does not show up. its the same with names, if you search for "bar" and order by "barbara" does not show up.
I searched the code for ways to change this but i could not find it.
Is there a way to change this so that a search term of "123" turn up order "0000000123" and that a search for "bar" would show up orders made by barbara?