5 Replies Latest reply: Aug 20, 2012 8:34 AM by tron RSS

    Undesired fuzzy search

    tron
      I have a results table and I have created some simple search mappings between messageTextInput items and messageTextInput in the table. They seem to work fine except the string seems to be doing a fuzzy search when I don't want it to.

      For example, I have records with values:

      123.1.2
      123.1.23
      123.1.234

      When I enter 123.1.2 for my search it gives me all 3 as results which seems to be the same as saying LIKE '123.1.2%', which is not what I want. I need it to be 123.1.2 if that is what my search was. Any ideas on what I am doing wrong?