0

this open source thing I am using uses typical contains formsof inflections. I will post the exact syntax if you want.

However, it does not do partial word search. How do I incorporate wild-card search with contains formsof inflections?

2
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by sknake
0

What are you talking about?

>>this open source thing I am using uses typical contains formsof inflections
Open source ... database? Is this even MSSQL?

>>However, it does not do partial word search. How do I incorporate wild-card search with contains formsof inflections?

If what contains it? A file, a table, ... ?

0

What are you talking about?

>>this open source thing I am using uses typical contains formsof inflections
Open source ... database? Is this even MSSQL?

>>However, it does not do partial word search. How do I incorporate wild-card search with contains formsof inflections?

If what contains it? A file, a table, ... ?

My question was extremely unclear, wasnt it? :)

Yes, I am talking about MS SQL Server.

http://arcanecode.com/2008/05/27/using-formsof-in-sql-server-full-text-searching/ <-- this link is talking about the search thing I am referring to. What I am looking for though is a way to use some sort of wild-card search in there too.

This is the typical syntax:
CONTAINS(sampletable.samplecolumn, ‘FORMSOF(Inflections, samplesearchterm)’)

so it looks for samplesearchterm in samplecolumn of sampletable. How do make it do wild-card search?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.