[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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