Results 1 to 5 of 5
  1. #1
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110

    Find a string within a string

    I'm trying to query for all the records in a table in which the field named [Description] contains the phrase "High Rise". The phrase could be anywhere within the field. I assume I should use the InStr() function, but I'm not having any luck. Any help would be appreciated.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    WHERE [Description] LIKE "*High Rise*"
    see the uses of LIKE operator with wild cards
    https://support.office.com/en-ie/art...9-eef18358e931
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    note that Description is a reserved word, as is Desc and many others. Google 'Access Reserved Words" for a full list

  4. #4
    cebrower is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Spring Lake, MI
    Posts
    110
    Perfect. Thanks much.

  5. #5
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    DANG!! I missed that one. Usually I notice, but hey, who can remember over 2600 words??

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Find or filter for a string
    By cebrower in forum Programming
    Replies: 3
    Last Post: 02-27-2019, 02:09 PM
  2. Replies: 5
    Last Post: 06-15-2018, 03:14 PM
  3. RegExp to Find String at END of a String
    By Micron in forum Programming
    Replies: 3
    Last Post: 01-17-2018, 09:43 PM
  4. Need Help to find SQL connections string
    By datadc in forum Access
    Replies: 4
    Last Post: 01-16-2017, 08:37 PM
  5. Replies: 2
    Last Post: 04-05-2015, 06:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums