record searching

[Guest]

Hi im currently using an Freedom of Information database and have a question
regarding searching the database.

there is a field called request details where details of the persons request
for information is typed in.

i was wondering whats the easiest way to search a field with a lot of text
in it? say the person wanting to search for something like "information on
how much council has spent in last year"

is it possible to search for something like this?

 

[Arvin Meyer [MVP]]

It's not really fast to search all the text in a Memo field or large text
field, but you'd write a query something like:

Select * From MyTable Where MyMemo Like "*Council*" & "*spending*";

Search for that in say 15 MB of text in 5000 rows takes about 3 seconds.