January 25, 2007 at 10:59 am
I am trying to query a full text catalog built around customer data. It contains names, street elements, city, state and zip code.
My query is simple:
select * from dbo.CUSTOMERKEYWORDS where contains( CUSTOMERDATA, '"travis*" AND "w*" AND "898*"')
What I get is:
Server: Msg 7643, Level 16, State 1, Line 1
Your search generated too many results. Please perform a more specific search.
This occurs anytime I search for a 3 digit number with a * at the end.
If I make it 8982 then the search will be just fine and return the customer record I am looking for.
This leads me to two questions.
Why does contains have problems with 3 digit numbers, or is it really to many records. A like search only returns 14 rows matching the same pattern.
Is there a better way to do this?
I tried freetext but it is important that I only get the records that match all of the results and free text doesn't seem to get the full zip code of 89822.
January 29, 2007 at 8:00 am
This was removed by the editor as SPAM
January 30, 2007 at 12:37 pm
Anyone?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply