I am new to Full-Text search and learning about it.

I am having an issue with the number of rows retrieved.

The 1st query shown below

[code]Select Ai_Id,Ai_Texto FROM  tblAvisosInternet
WHERE Ai_Texto like '%Toyota%' AND Ai_Texto like '%Yaris%'
ORDER BY Ai_Id
[/code]

retrieves 622 rows

Then I started using the CONTAINS keyword

[code]Select Ai_Id,Ai_Texto FROM  tblAvisosInternet
WHERE CONTAINS(Ai_Texto, 'Toyota AND Yaris')
ORDER BY Ai_Id[/code]

or
[code]
SELECT     Ai_Id, Ai_Texto
FROM         tblAvisosInternet
WHERE     CONTAINS(Ai_Texto, '"%Toyota%" AND "%Yaris%"')
ORDER BY Ai_Id[/code]

this retrieves 552 rows missing rows such as "TOYOTA YarisSport
2005...." where Yaris is glued to another word

On another forum somebody suggested this

[code]
Select Ai_Id,Ai_Texto FROM  tblAvisosInternet
WHERE CONTAINS(Ai_Texto, '"*Toyota*" AND "*Yaris*"')
ORDER BY Ai_Id
[/code]

Which retrieves 571 rows missing rows such as "TOYOTA NewYarisSport,
año2007,".

What am I missing ?

jean-luc
www.corobori.com