CONTAINS sql function don't see underlinings

Question

I have some table 'TableName' like Id,Name:

1 | something
2 | _something
3 | something like that
4 | some_thing
5 | ...

I whant to get all rows from this table where name containes 'some'. I have 2 ways:

SELECT * FROM TableName WHERE Name like '%some%'

Result is table :

1 | something
2 | _something
3 | something like that
4 | some_thing

But if I use CONTAINS function

SELECT * FROM TableName WHERE CONTAINS(Name,'"*some*"')

I get only

1 | something
3 | something like that

What should I do to make CONTAINS function work properly?

Answer 1

Hi,

http://doc.ddart.net/mssql/sql70/ca-co_15.htm

If you read this article you will see that * means prefix this means that word must start whit this but like means the word contains key phrase

Best Regards, Iordan

Answer 2

Try this:

SELECT * FROM TableName WHERE CONTAINS(Name,'some')

Answer 3

The last time I looked (admittedly SQL Server 2000) CONTAINS didn't support wildcard matching at the beginning of words, only at the end. Also, you might need to check your noise files to see if the "_" character is being ignored.

Also see

http://stackoverflow.com/questions/3400/how-do-you-get-leading-wildcard-full-text-searches-to-work-in-sql-server