By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,870 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,870 IT Pros & Developers. It's quick & easy.

CONTAINS clause with multi-word "AND" inflectional searching??? help...

P: 6
What if you want to search using FTS with AND logic using the FORMSOF(inflectional,...) inside the CONTAINS() clause???

if my search phrase is "light hearted" I can easily do an OR search using the following in my where clause:
CONTAINS(Colname,'formsof(INFLECTIONAL,light,heart ed).
but the and is far more tricky....

does anyone know how to do this without having multiple Contains statements (which greatly increases overhead)?

I know that I can use AND in a straight contains like so:
CONTANS(column, '"light" AND "hearted"') but this does not allow me to explore inflectional variations on the words...

nesting multiple FORMSOF's doesn't seem to work either like so:
contains(column,'"formsof(inflectional,light)"' AND 'formsof(inflectional,hearted)"')

anyone else found how to do this?
Jan 22 '07 #1
Share this Question
Share on Google+
3 Replies


P: 6
just to clarify I think 2 better search words for my ex. would have been "sport" and "award" and it's really important that I get results for Sports, Sported, Awards, and Awarded. Then I'd have any combination of the two words Inflectional variations (one from each root word) that exist in the same record returned in my resultset.
Jan 22 '07 #2

P: 1
Hello garrettm,

I've been googling like crazy and it seems that I have the same question that you have. Did you ever find a solution? For me, the following formsof clause compiles but it doesn't return results:

formsof(inflectional, "surreal artist")

Although there is clearly the phrase "surreal artist" in my database. Using freetexttable, I do get it in my result set--but I like the control I have with containstable.
Dec 27 '07 #3

P: 6
Hello garrettm,

I've been googling like crazy and it seems that I have the same question that you have. Did you ever find a solution? For me, the following formsof clause compiles but it doesn't return results:

formsof(inflectional, "surreal artist")

Although there is clearly the phrase "surreal artist" in my database. Using freetexttable, I do get it in my result set--but I like the control I have with containstable.
I posted the answer on WIKI in the discussion page...
HERE IS THE LINK
Dec 28 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.