[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

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.
0
namol
Asked:
namol
  • 4
  • 2
3 Solutions
 
BrandonGalderisiCommented:
Full Text indexing isn't like a % wildcard like search.  But you can do it by using * I believe.

ex: 110*
0
 
namolAuthor Commented:
You can use the asterisk as a wild card but for some reason when I do use it, it doesn't return the expected results.
IE:

TableData

QuoteNum
1239910101
9851452102
7777777777

a sql statement like
SELECT QuoteNumber
FROM         TableData
WHERE     CONTAINS(*, '"*77777*"')
will return no results but if I searched for *777* it would yield the desired results.
0
 
BrandonGalderisiCommented:
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?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
namolAuthor Commented:
sql server 2005 sp4
0
 
namolAuthor Commented:
Well, the work around for my issue is checking to see if the string is numeric and then performing a search based off using like '%11%'.
0
 
namolAuthor Commented:
Lack of activity on this question forced me to experiment to find the answer.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now