Do anybody know an good algorith to search a string by ado

Let say i have
SELECT * FROM StrTemp WHERE [Search] LIKE '%" & Search & "%'

i want to find = "John Miller"

In the database i have a string like: "I am Miller John", so i just want to know how can i use ADO to find that string, with the "John Miller" or "Miller John" critia.

Thanks
Of course i can't loop all the string in the database, because i have 100 000 records, it gonna take to much time.