2 Replies Latest reply on Aug 3, 2007 9:09 AM by cf_dev2

    Finding items in a list

    hml398 Level 1
      It's been a long week and I know this is simple but I can't for the life of me get it to return properly.

      I have someone who enters a keyword to do a search and before the system searches, it looks through a synonym table to add any to the keys to search for. If someone enters "AF" - there are two listings - one for AAF and one for AF - obviously I don't want the AAF one because it means something different than AF. So if I do a WHERE Synonyms LIKE '%#TRIM(i)#%' - it returns a whole bunch of records including those that have "AF" in the middle of the word. Help!!