punctuation in fulltext searches

I am using Fulltext search in a web application I wrote for our
company that is bascially a knowledge base search engine - the app
searches and returns matches against our SQL 2000 database. The
problem I am having is this:
I cannot seem to figure out how to search for phrases, booleans, and
search terms with punctuation, etc.
For example:
searching for the filename history.dbf becomes historydbf
searching for "this exact phrase" becomes the 3 seperate keywords
this, exact, and phrase.
I currently have code in the web app that strips out punctuation and
anything other than letters/numbers, because when I was allowing them,
my searches were blowing up with errors.
Can anyone help me to understand how can I allow these kinds of
searches without blowing up the app or crashing the sql search?
The app is located at http://www.resourcesystem.com/kb
Thanks in advance for any help or advice anyone might have for me!
Brad Miller
bmiller@.tdpi.com
I'm a little confused by your question. When I search on history.dbf I get
hits to history.dbf not historydbf.
If I search on "this exact phrase" using contains, I get hits to only "this
exact phrase"
If I search on boolean phrases, ie "this and that" the boolean operator is
ignored. It is effective when you do contains searches though.
Can you perhaps post your exact query here?
"Brad Miller" <bmiller@.tdpi.com> wrote in message
news:37725671.0403241019.7c4a8270@.posting.google.c om...
> I am using Fulltext search in a web application I wrote for our
> company that is bascially a knowledge base search engine - the app
> searches and returns matches against our SQL 2000 database. The
> problem I am having is this:
> I cannot seem to figure out how to search for phrases, booleans, and
> search terms with punctuation, etc.
> For example:
> searching for the filename history.dbf becomes historydbf
> searching for "this exact phrase" becomes the 3 seperate keywords
> this, exact, and phrase.
> I currently have code in the web app that strips out punctuation and
> anything other than letters/numbers, because when I was allowing them,
> my searches were blowing up with errors.
> Can anyone help me to understand how can I allow these kinds of
> searches without blowing up the app or crashing the sql search?
> The app is located at http://www.resourcesystem.com/kb
> Thanks in advance for any help or advice anyone might have for me!
> Brad Miller
> bmiller@.tdpi.com
sql