Full Text Indexing Question

• Rick Hodder

  Old Hand

  Points: 359

  More actions

  September 30, 2005 at 11:27 am

  #166285

  Hi,

  I am using full text indexing to perform searches on inflectional forms of words. For example, the following CONTAINS clause will find rows where the description field contains the word dry and its inflectional forms (dried, dries, drying...):

  CONTAINS (description,' FORMSOF(INFLECTIONAL,dry) ')

  That works beautifully.

  Now here's the problem. In the form that I will show the results of this query to the user, the client has requested that I highlight the words being searched for. CONTAINS only lets you know it exists in the field, not which inflectional form it found.

  Is there some functionality in fulltext indexing that I can ask it for the inflectional forms of words? In other words, can I execute a command that will give me a result set of the inflectional forms found in the search, or the inflectional forms of the word I'm searching for?

  Thanks,

  Rick

  ---

  Thanks,

  Rick Hodder

• October 3, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Rick Hodder

  Old Hand

  Points: 359

  More actions

  October 3, 2005 at 8:54 am

  #594594

  Anyone, beuller?

  

  ---

  Thanks,

  Rick Hodder