Full Text Search??

[Aaron Abdis]

Hello,

Its been a while since i did any access work, shortly after i started i
switched over to ORACLE, and have been there ever since.

In Oracle, and SQL*Server, you have the ability to do full text
indexing/searching of text fields. In Oracle it is done using a CONTAINS()
sql operator. I dont know how exactly in SQLS

Is there any way to do something equivalent in Access? using LIKE doesnt
quite cut it, and the only alterative i can find is breaking my keywords
field out to one row per keyword, and searching down the rows, instead of
across the field... which of course, is FAR from the ideal way to do this.

Thanks in advance,

- Aaron.

 

[Ken Snell]

You can do a "has" search on a field's contents using this WHERE expression:

Like "*" & "TextToFind" & "*"

 

[Ken Snell]

You can do a "has" search on a field's contents using this WHERE expression:

Like "*" & "TextToFind" & "*"

 

[Aaron Abdis]

Yah, that would be a simple approach. However here is the case im in...

I have a project where the client wants a website where you can type in a
bunch of keywords, and it will find all the businesses containing those
words in their KW lists. in oracle i would do a CONTAINS(TextField, 'My Key
Word list to find') [roughly] and it would find all records with those words
IN ANY ORDER. To try to do that with a like would require doing a LIKE
"*W1*W2*W3" for every combination of those words. not exactly clean. Since
LIKE matches it in Exact order.

Maybe there is some add-on provided by a 3rd party which gives Real full
text search to Access??

TIA -

 

[Stewart Tanner]

what is wrong with like *w1* and like *w2* and like *w3* etc

you should be able to build a criteria string like that without any problems
for the key word list.

Yah, that would be a simple approach. However here is the case im in...

I have a project where the client wants a website where you can type in a
bunch of keywords, and it will find all the businesses containing those
words in their KW lists. in oracle i would do a CONTAINS(TextField, 'My Key
Word list to find') [roughly] and it would find all records with those words
IN ANY ORDER. To try to do that with a like would require doing a LIKE
"*W1*W2*W3" for every combination of those words. not exactly clean. Since
LIKE matches it in Exact order.

Maybe there is some add-on provided by a 3rd party which gives Real full
text search to Access??

TIA -

You can do a "has" search on a field's contents using this WHERE expression:

Like "*" & "TextToFind" & "*"

 

[Aaron Abdis]

Ahhh... yes, that would do it in a pinch. Sometimes its the simplest things
which you completely overlook.
Its not perfect, it wont give all the fancy soundex and synonymizing of a
real text index, but it will certainly get the basic job done.

Thanks!

what is wrong with like *w1* and like *w2* and like *w3* etc

you should be able to build a criteria string like that without any problems
for the key word list.

Yah, that would be a simple approach. However here is the case im in...

I have a project where the client wants a website where you can type in a
bunch of keywords, and it will find all the businesses containing those
words in their KW lists. in oracle i would do a CONTAINS(TextField, 'My Key
Word list to find') [roughly] and it would find all records with those words
IN ANY ORDER. To try to do that with a like would require doing a LIKE
"*W1*W2*W3" for every combination of those words. not exactly clean. Since
LIKE matches it in Exact order.

Maybe there is some add-on provided by a 3rd party which gives Real full
text search to Access??

TIA -

You can do a "has" search on a field's contents using this WHERE expression:

Like "*" & "TextToFind" & "*"


--

Ken Snell
<MS ACCESS MVP>

Hello,

Its been a while since i did any access work, shortly after i

started

i instead
of