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.
LVL 7
namolAsked:
Who is Participating?
 
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
 
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
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
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
 
namolAuthor Commented:
sql server 2005 sp4
0
 
namolAuthor Commented:
Lack of activity on this question forced me to experiment to find the answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.