I have problem with FullText Serach on SQL Server 2008.
I have table Movies, with FullText Index on column Title.
In this column I have many values with "." and "_", like this:
Problem is when I try to select all rows with "Bill". My query:
SELECT * FROM Movies m INNER JOIN FREETEXTTABLE (Movies, Title, 'Bill') ft on m.Id=ft.[KEY]
because in answer I get nothing. WHY?
What should I do, to make it work?