memo field searchable?

  • Thread starter Thread starter wmerrick
  • Start date Start date
W

wmerrick

is the memo field searchable? We want to use it to record
notes, and we want to search the notes in the future by
keywords...
 
is the memo field searchable? We want to use it to record
notes, and we want to search the notes in the future by
keywords...
Click to expand...

Certainly. You cannot put an index on it, so the search may be slow if
you have a lot of records and/or a lot of text in the memo field, but
a Query like

SELECT * FROM MyTable
WHERE memofield LIKE "*zebra*"

will find all the records containing zebra in the memo field.
 
Back
Top