Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imgharavi
Starting Member
5 Posts |
 Posted - 2011-06-05 : 14:05:31
|
| hi, I have a table with more than 50,000 rows. my clients search this table with " like '%xxx%' " and they search any part of a filed which contain phone number, postal code and so on.the speed of search is more than 2 sec so i replaced this solution to full-text index and the performance increased and query executed in less than 500 ms.the only problem i have is searching a part of numeric values. for example if the phone number is 09125995019 we could not return this row with contain(*,'*5995019*').I read somewhere in forums that full-text is only for words but i could not accept it because numbers could be a part of words so why it does not return true result? |
|
|
|
|
|
Full-text seach on numberic values