Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 How will I achieve this. FullText Inflectional

Author  Topic 

sudheepdivakar
Starting Member

5 Posts

Posted - 2010-01-14 : 12:00:39
In a table I have two columns. One is a primary key and other is a varchar(max) column named "Keyword".

My query is
"select Keyword from Keywords where freetext(Keyword,'knit')"

this will give me following result.
"23" "knitted"
"36" "knitting"

What query can give me result like shown below
"23" "knit" "knitted"
"36" "knit" "knitting"

Regards
Sudheep
   

- Advertisement -