namol
asked on
SQL Server 2005 returns no results when searching for 4 or more digits
I'm having an issue with Full Text searching on a selected table. I can search for numbers but any number that has four or more digits does not return any results.
IE: 110 will return a list of all the fields with 110 in it. 1100 will not return any results.
IE: 110 will return a list of all the fields with 110 in it. 1100 will not return any results.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Unfortunately I don't have a lot of experience working with full text indexes so I'm not sure. What service pack are you using?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Lack of activity on this question forced me to experiment to find the answer.
ex: 110*