CODEWITHSUNDEEP
sqlsql-server
Greg
Greg

Reputation: 1367

looking for word parts with full text search in sql server

how do I find, with full text search all words that match 'ability' mask, like "suitability" and "dependability", etc? is that possible?

Upvotes: 5

Views: 2940

Answers (2)

user97410
user97410

Reputation: 724

I've had that problem, and there didn't seem any nice way round it but to also chain OR WHERE x LIKE "%term%" searches in each individual field.

Upvotes: 0

mdma
mdma

Reputation: 57747

It's not possible out of the box. Apparently wildcards do not work. See here for discussion.

Upvotes: 2

Related Questions