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?
progtick 0 Newbie Poster
progtick 0 Newbie Poster
I am talking about search feature btw
sknake 1,622 Senior Poster Featured Poster
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, ... ?
progtick 0 Newbie Poster
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?
sknake 1,622 Senior Poster Featured Poster
Ah.. I have never used FTS. You're out of my league on this one.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.