Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Is there a way to search for this...including the quotes "..

 
   Database Help (Home) -> Full Text RSS
Next:  Videos from the last osbootcamp on web programmin..  
Author Message
Kyle Jedrusiak

External


Since: Jul 23, 2008
Posts: 3



(Msg. 1) Posted: Wed Oct 01, 2008 8:16 am
Post subject: Is there a way to search for this...including the quotes "as is" or "to be"
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)

Could also be we're doing something wrong.

If we try our search specifically using "as if"...it doesn't find any
matches.

Kyle Jedrusiak

 >> Stay informed about: Is there a way to search for this...including the quotes "".. 
Back to top
Login to vote
Russell Fields

External


Since: Jan 10, 2008
Posts: 608



(Msg. 2) Posted: Wed Oct 01, 2008 8:43 am
Post subject: Re: Is there a way to search for this...including the quotes "as is" or "to be" [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Kyle,

If you have not edited your noise word list, then as, be, if, is, to are all
noise words and are not indexed. That means, of course, that you cannot
search for them.

To get those words included you will need to edit the noise word list for
the language you are using to remove those words from exclusion. If you
want no words excluded, edit the noise word list down to a single blank.
(Or, a single impossible word.) Then you will need to rebuild the index(es)
that are affected.

Since I am in the US, I have a noiseENU.txt that is unedited and a
noiseENG.txt that has no noise words in it. I can then set the language for
fulltext indexing to either English (actually American English,
noiseENU.txt) or to British English (noiseENG.txt).

RLF

"Kyle Jedrusiak" wrote in message

> Could also be we're doing something wrong.
>
> If we try our search specifically using "as if"...it doesn't find any
> matches.
>
> Kyle Jedrusiak
>

 >> Stay informed about: Is there a way to search for this...including the quotes "".. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Boolean search - Hi all! This is my problem, I hope you can help me... I have an asp web site. I want to search, for exemple in a table of addresses, the string "apple+table", to have all the record in my table where in a list of fields (like name, address, t...

'"n*"' prefix search - Can you tell me why a prefix search like: SELECT <column_list> FROM <table> WHERE CONTAINS(<column1>, '"n*"') (<column1> is a "nvarchar") returns not only records containing text beginning with "n", ...

fulltext search not working - HI!, Fulltext search is not working, i have two databases, fulltext search functionality was working fine on both of them till now. but suddenly fulltext search on one of the databases started giving out errors. when i try to populate, rebuild was..

Product name search Best practices - Hi, I have enabled full-text search on ProductName column of my Products table, using ProductId (PK) as key. My asp.net web aoolication, filters the search (remove none alpha-numeric and unwanted chars) and pass it as parameter to the stored..

funny search results with 'contains' clause - hi, it is really funny how ft search works: it seems to depend highly on what could be indexed, but it still doesn't follow a determined order. consider the following queries: select name from person where contains(name, 'hammer') select name from..
   Database Help (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]