+ Reply to Thread
Results 1 to 3 of 3

ADO Reverse (in string) partial match query

  1. #1
    Forum Contributor
    Join Date
    03-11-2021
    Location
    india
    MS-Off Ver
    365
    Posts
    154

    ADO Reverse (in string) partial match query

    Hello,

    I know how to search ocurrences of a search term within a field values using LIKE.
    If you searched for "Apple" this would return "Pineapple"
    Please Login or Register  to view this content.

    But I am trying to do the reverse, so searching "Pineapple" would return "Apple" because apple is within pineapple.

    Is there any syntax to do this or do I have to retrieve the whole table and loop through it?

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: ADO Reverse (in string) partial match query

    Just swap them:

    Please Login or Register  to view this content.
    Rory

  3. #3
    Forum Contributor
    Join Date
    03-11-2021
    Location
    india
    MS-Off Ver
    365
    Posts
    154

    Re: ADO Reverse (in string) partial match query

    Great thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Reverse Partial Match VLookup
    By nathan0918 in forum Excel General
    Replies: 9
    Last Post: 07-15-2021, 04:09 PM
  2. [SOLVED] VLOOKUP Reverse Partial match question
    By blakeaces in forum Excel General
    Replies: 7
    Last Post: 10-04-2019, 12:47 PM
  3. Reverse Vlookup Partial String Match
    By Premmadaan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-22-2018, 08:38 PM
  4. Reverse Partial match lookup
    By Stueymac in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-05-2013, 05:12 AM
  5. Trying to match partial string with another string and give position or cell
    By pat3white in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-01-2013, 10:07 AM
  6. Reverse Table Lookup using a partial string
    By pat3white in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-27-2013, 01:35 PM
  7. [SOLVED] Vlookup, Match (Search or Find) partial string within string in a Cell
    By dluhut in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-28-2013, 12:40 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1