Freetext alternative in ACCESS

[Guest]

Is there a way to duplicate the functionality of the FREETEXT predicate in
SQL? I'm trying to do a multi-word search that doesn't result in an exact
match of the multi-word phrase. Any help would be greatly appreciated.

 

[Tom Ellison]

Dear MSLee:

Don't know anything about FREETEXT but there is SOUNDEX. You could look at
it and give it a try.

Tom Ellison

 

[John Spencer]

Could you expand a bit on what you want?

If you want to input a phrase and then find records where all the phrase
words are in a field but in any order, then you could do this with a bit of
VBA to write your SQL statement.

I imagine that there might be a regular expression that could be used that
might do this. Unfortunately, I'm not at all good with regular expressions.