I have a working ASP app that extracts current news articles from an 

Access database. The body of the articles are stored in MEMO fields. I am 

now at the point in development where I am starting to think about adding 

search functionality and have no idea of how to search for a phrase or a 

particular word contained within MEMO fields.



Any suggestions would be appreciated, even if it involves using another 

schema that excludes MEMO fields. I used MEMO fields because I could very 

easily add an entire article to a web page using one field like 

Response.Write ("ArticleField").



Thanks in advance.



Brian.