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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
namolAuthor Commented:
Lack of activity on this question forced me to experiment to find the answer.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.