I have a situation like this

TAble1
ID Title
UsersCount
1 "the da vinci code"
10
2 "The Da Vinci Code and the Secrets of the Temple" 5
3 "The Da Vinci Code Decoded"
2

I want to have a search that when I search for 'the da vinci code' rank the
results as
1,3,2 because the first book match exactly the phrase while the others have
a density of keywords lower,

I'm trying to do something like this
SET @SearchConditions = 'ISABOUT("the da vinci code" WEIGHT(.9), "the"
WEIGHT(.1), "da" WEIGHT(.1), "vinci" WEIGHT(.1), "code" WEIGHT(.1))';

SELECT * FROM FREETEXTTABLE(xefba_db_Books, Title, @SearchConditions)

but CONTAINSTABLE explode with more than 3 words to weight and FREETEXTTABLE
gives inaccurates results...

This has propably been asked before - sorry.

Our Users would like to search for Strings that contain special characters
and I need to figure out a way to do this with SQL Server 2005 full-text
search (example would be 'Job#$23#3'). After searching the net I couldn´t
really come up with a sufficient answer to this demand. It would be great if
you could point me at a resource that explains how to get this done.

Thanks,
El

commander meridia canada en ligne Achat meridia canada Simple meridia canada sans ordonnance commander comprime de meridia us usa commander meridia canada en ligne

If I have a FT Index with a varchar field, and there are two rows:

1234
1234AV

If I run a freetexttable query against that index searching for '1234', why
does it only return the first row and not the second? Is there any way to
get it to return both rows, or would I have to use containstable with a
wildcard?

I've been using freetexttable because it works very well when the search
term contains multiple words, but I'm not sure what to do to get it to match
against partial strings like the case above?

I have a full text cat for "products" set up against a table with product
information such as product-ID, product-name, product-description, all of
which are in the view. All the fields are varchars.

I have two similar products with similar product-IDs, like:

1234
1234XL

If I perform a freetexttable query against the view, and search for "1234",
only the first product is returned (and if I search for "1234XL" the second
is returned). If I embed "1234" in the product-description for both
products, then both products are returned.

So, it seems like my freetexttable query is looking for an exact string
match...which I guess would make sense. But I'm wondering if there's any way
for it to perform something closer to a "Like" query:

select * from table where product-ID like '%%1234%%' --which would return both
products.

My real query looks like:

detektei ses privatdetektiv aachen personenschutz frankfurt detektive frankfurt privatdetektive detektei detektivbuero detektei objektschutz

hello to everyone ,

We have in our company a two nodes active-passive cluster with SQL Server
2000 SP4.
Recently one of our customer required from us to create a full text
catalog for some tables & columns
for his database.
So we made it ,but we realise that Microsoft Search didn't work when we
use a query in order to check it if it works fine.
The service was running and i tried several times a restart of the
service.
For example we made a full text catalog for the table "News" and the
column "newstuff" .

Then we run this query : SELECT newstuff FROM news
contains(prices,'suspeding')
and the answer was nothing ,not error ,not message ..just nothing.

If we run this instead : SELECT newstuff FROM news where newstuff like
'%%suspen%%'
we took as a result hundreds of lines and that is correct.

HI,

I am writing a stored procedure for my search box control. I found
this sample code which sets the @WORD1 to 'TBB-12' and searches 1
table for the information. I set the value to TBB-12 and specified to
look in the dbo.product_id. It did find the product id = TBB-12 on the
first result row, however, it return a bunch other rows, which none of
the column fields contains the value 'TBB-12'. In theory, a search
should only return 1 row, correct? Why am I getting a bunch extra
useless rows? What is wrong with the sql query?

Thanks,

John

3 * dbo.WordCount('TBB-12', (actress1.fullname + ' '
+actress2.fullname + actress3.fullname + ' ' + actress4.fullname + '
'+ actress5.fullname + ' '+ actress6.fullname + ' '+ actress7.fullname
+ ' '+ actress8.fullname + ' '+ actress9.fullname + ' '+
actress10.fullname)) + dbo.WordCount('TBB-12', dbo.dvd.product_id)

SELECT dbo.dvd.dvdid,
COALESCE(actress1.fullname+',',actress2.fullname+',',actress3.fullname
+',',actress4.fullname+',',actress5.fullname+',',actress6.fullname
+',',actress7.fullname+',',actress8.fullname...

Hello there.

I'm new on FullText Search.

I need this in order to find part of words on 3 of my columns in table
(Table1(Txt1, Txt2, Txt3)

I've discovered the function CONTAINSTABLE(...) which brings me rank of
find.

what is the logical of ranks?

Hello All,

I have a sql server 2005 db which contains a full text catalog on a
table, certain columns on that table have a words with hyphens in them,
the customer expects the results to come up when the search term
contains hyphens, but looks like the indexing service uses hyphens as
word breakers and thus separates them out.

I have tried changing the full text language to neutral on the server
and rebuilding the db but that dint help, is it supposed to behave this
way and is there any configuration changes for this behavior ?

we are using 1033 as the language and using containstable clause to
search in a full text catalog.

thanks