Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Using 'Like' to filter in a query (2002)

    Hi,

    I have a query that I need to filter for items that have the word "Assessment" or "Recert" in any part of the text. My problem is that it only filters if Assess or Recert is the first word. In many instances the word may be in the middle of the text, shuc as "RN Assessment". Is there a way to use "like" to filter for a word in the middle of a group of words.

    Thanks,
    Leesha

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Using 'Like' to filter in a query (2002)

    The LIKE operator can use wild cards. Use * to denote any number of characters, use ? to denote a single character. For example, say your text field was myText, the selection criteria you wanted would be:
    myText LIKE "*Assumption*" or myText Like "*Recert*"

    Note the use of the * both before and after the word you wanted.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Using 'Like' to filter in a query (2002)

    Thanks Mark! I didn't have the * in after the word. It worked perfectly!

    Leesha

Posting Permissions

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