Problem in SQL server2005 Search..

[hvgyufg28fh38tyr78hf]

Hai All, I am doing following search in SQL Server2005, select * from table_1 where contains (text1,'"roll-over"') Results: 1 roll 2 notify us theday you roll check . 3 notify us the day you check roll-over. 4 notify us the day you check roll over. Could Some one tell me , is this results are right for this search?, i feel its wrong it should only return the line which is having roll-over ( 3 notify us the day you check roll-over.) how can i use this query or modified this querey to get proper results? thanks Mahe

[Blue_Boy]

You can try this search: select * from table_1 where columnname like '%roll-over%'

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

[Lost User]

hvgyufg28fh38tyr78hf wrote:

Could Some one tell me , is this results are right for this search?

I'm not sure, but the documentation says that punctuation is ignored;

Punctuation is ignored.

I guess that you're searching for two separate terms in your query. Look through your resultset; there's 4 results that got either term. The source for this answer is here[^], under the heading "simple_term".

Merry Christmas :thumbsup: