>Back to what it was about: the search options. You give an impression of me as being someone who asks the world for just some dollars. But in fact I'm only asking for something that I'm offering my own clients every day again. You need not tell me what SQL-Server is capable of and what not. It is absolutely capable of retrieving just that what I occasionally want: an absolute lookup. You promissed an exact search if the string was in (double) quotes and so far you have not done what you promissed. I don't care if it can only be done somewhat slowly, as long as it can be done.
>
>I have the impression that your code still contains a bug, simple as that. If I enter a quoted string, then your program should not/never answer that digits, short words and the like are not permitted. It indicates that you pass the string to the wrong algorithm.
>
>I'm not asking for the moon. I'm asking for the exact search you promissed time and again and have failed to deliver sofar.
>
>UPDATE: I have attached a picture that proves that I enter a string in double quotes. And see what message appears!
I'm thinking, that if we search for exact phrase, we just need to ensure that at least 1 of the words is more or equal than 3 characters (not every word). With that it should be able to utilize FULL TEXT search and then limit based on the exact phrase using LIKE.
If it's not broken, fix it until it is.
My Blog