0

hai all

i am facing some problem in SQL.I am searching the one string(ex.roll-over) in table
its returning wrong results.
my table contains,

dable datas
table_1 is table name
number1 text1
1 notify us the day you roll check over.
2 notify us theday you roll check .
3 notify us the day you roll check roll-over.
4 notify us the day you roll check roll over.


my query is
select * from table_1 WHERE CONTAINS(text1, '"roll-over"')
select * from table_1 WHERE CONTAINS(text1, 'roll-over')

in both case i am getting below results.
results
number1 text1
1 notify us the day you roll check over.
2 notify us theday you roll check .
3 notify us the day you roll check roll-over.
4 notify us the day you roll check roll over.

here it should return only one result insted of four.
is there any thing wrong in Query if not can any one help to from the correct query.
i think Bcoz os hyphen the result is returinig either roll or over presents.


thanks
mahe

2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by thecheesewheel
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.