[RESOLVED] ADO Search Agorithm

[Vntalk]

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.

[si_the_geek]

The simplest way is to use multiple Like conditions, one for each word, eg:

SELECT * FROM StrTemp 
WHERE [Search] LIKE '%John%'
  AND [Search] LIKE '%Miller%'

Depending on which language you are using, you may be able to use the Split function to get the words from the search criteria.

[Vntalk]

thanks