Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-08-31 : 19:41:49
|
Ritchie writes "I am using ASP and an Access 97 database running on Win2000 (but I'm sure the same applies to SQL servers) which has a table containing a memo field which is basically freeform text entered by users.
I have a basic searching routine (select * from table where field Like %searchphrase%) which works OK but obviously isn't too clever when it comes to searching for words in another order e.g.
content of memo field is "blue car old"
Searching for "old blue car" or "car blue old" won't return a match.
I'm sure that 1,000 people before me have thought about this and written the code which parses the words etc. - can you point me in the right direction of something which I could use as a starting point. I've looked at all the decent ASP sites to no avail ...
Many thanks"
|
|
|
|
|
|
searching memo field data for key phrases matching all words in phrase irrespective of their order