Hi

I have been trying to find a query method in sql.  Google engines search
phrases and find the best suitable result .
for instance if you write (play station) it can find all suitable result in
"playstation" or "play station" but I could not do it in sql(2000) even in
fulltext search
I tried to use LIKE operator in the query " where article like '%play%' or
'%station%' or '%playstation%'  but the result comes with unneeded rows
I also try contains or freetext with "near" or all kind of attributes and no
success I wonder how the google search phrase words and find the suitable
results
do you have any experience about the issue ? any advice would be helpful

Tanks