Results 1 to 2 of 2

Thread: Query??

  1. #1
    Join Date
    Dec 1969

    Default Query??

    I have a database with five fields. One of which is a memo field which usually contains about 50 words. I want to be able to search this field by keyword. Can someone give me any hints to the best way to search through the memo field in a database for keyword or keywords.

  2. #2
    Scott S Guest

    Default RE: Query??

    I don&#039t Know the exact syntax for ACCESS but in SQL Server this works:<BR><BR>SELECT * FROM TABLE WHERE TEXTFIELD LIKE &#039%KEYWORD%&#039<BR><BR>Check the documentation to find the exact syntax, but that should get you there. <BR><BR>Hope that helps<BR><BR>Scott S<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts