Full Text Search

Hi,

Would below mentioned thing is possible in sqlserver 2005 full text.

User Table - Table

Id Description - Column name

1 'Mission Impossible' - a row

I want to ge this row if the search criteria is 'pos'. it is simillar to ' %pos%' in like search

is it possible to get that row using Contains() or Freetext(). I tried the following, but it doesnt return any rows.

CONTAINS(Description, ' "*pos*" ')

~ Arjun

SQLServer 2005 does not support arbitrary substring or regular expression yet. Right now you can only do prefix using fulltext.

|||

have u enabled the full text search in your server.

if so then you need not give the % symbol in the text which is to be searched. There is another option in the CONTAINS function.checkt it out.

please try this.

Ravi.