hello frends,
can any body tel me about searching code. my problem is if data strored in database in this form
employe code salary Range
1-2-3 100
3-4-5 200
1-2-5 150
2-3-4 175
emplotyecode involves different types of employes. if i fil in search box 2 it wil show first and fourth full record.
but condition is we can not use "like " keyword. with like it is working. you can also email me on my email ids_sarb@yahoo.co.in
Thanks
Hello,
Thanks for the post.
When you search for '2', doesn't it give back recoird #3 as well?
I assume you are using SQL Server FTS feature, right?
If so, you should know that the word breaker will parse the employe code and return back single numbers i.e: 1 2 3 ..., ach of these numbers will be tried to be FT indexed; however, by default, the noise word file (in English) will remove single digit numbers understanding that they are noise. This is the defaulyt behavior unless you change the noise files and remove the single digit numbers from the noise list.
Can you please let me know more details? as what are you using exactly? version? did you touch the noise files? are you finding what you expect? etc..
