LSAdvantage (8/31/2010)
Very good point: "So I would be looking for clarification of the requirements, and making it clear that there is a performance issue, if they want to search the middle of words."Thank you Jasmine.
Lisa
Exactly.
On the bright side, with a dynamic query, if they don't search on that one option, it won't do it.
I've actually got dynamic search queries that change the joins if specific text values aren't part of the search.