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!!