Query in Full-Text Catalog

[Ologhai]

ID text title
-----------------------------------
1 test test
2 itest itest
3 >test >test
4 <i>test <i>test
5 test22 test22
6 itest22 itest22
7 >test22 >test22
8 <i>test22 <i>test22
9 <i>test22 </i> <i>test22 </i>
10 <i>test </i> <i>test </i>


when i use this query

SELECT *
FROM texte
WHERE CONTAINS(*, '&quot;test*&quot;')

the result is this
1 test test
5 test22 test22
7 >test22 >test22
3 >test >test

Enclose a prefix term in double quotation marks (&quot;&quot and add an asterisk (*) before the ending quotation mark, so that all text starting with the simple term specified before the asterisk is matched

the result must be 1 and 5 why i got 7 and 3 ?

second question is, i want search 'test' in my database
and i want this result

ID text title
-----------------------------------
1 test test
2 itest itest
3 >test >test
4 <i>test <i>test
5 test22 test22
6 itest22 itest22
7 >test22 >test22
8 <i>test22 <i>test22
9 <i>test22 </i> <i>test22 </i>
10 <i>test </i> <i>test </i>

if the word 'test' is in my database i wanna see it
like '-------test------' it must be show me this row.

thanks to help me.
--------------------------------
Hugues Gauthier, DEC
Développeur Web

Intelligence Digital
1751 Richardson
Suite 4230
Montréal, Québec
H3K 1G6

http://www.intelligencedgt.com/

hgauthier@intelligencedgt.com
hugues_gauthier@hotmail.com

-------------------
ICQ: 2151800

 

[Ologhai]

Hello TeteLouch ,



i'll answer me because i found the solution

go in the full-text indexing wizard
in 'language for word breaker' dont chose english or french
chose Neutral.

thanks --------------------------------
Hugues Gauthier, DEC
Développeur Web

Intelligence Digital
1751 Richardson
Suite 4230
Montréal, Québec
H3K 1G6

http://www.intelligencedgt.com/

hgauthier@intelligencedgt.com
hugues_gauthier@hotmail.com

-------------------
ICQ: 2151800