This discussion is archived
5 Replies Latest reply: Aug 20, 2012 6:34 AM by tron RSS

Undesired fuzzy search

tron Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points