I think this is a very commonly known problem and has been discussed in general IT a lot of times. It would surely make a good ATK tutorial.
Ok, its about:
In the Database, I store
lastname of a person. I also have a search field in which persons can be searched.
Lets assume a person is called “John Smith”.
Now I want all 3 searches to return him as result:
So search either in firstname, lastname or firstname + lastname.
I will start digging into that now, if anyone has done this already please gimme a hint