System.Data.SQLite

Hi

Im ALI AL SALAMI 

I write very desktop applications with SQlite and C# or VB.NET

and I Understand that it's very nice

but in full text search has problem 

Table1 

C1

-----------------

MySchool

School

OurSchool

in sql server if you have  : MySchool and search 

SELECT  *   FROM   Table1   WHERE   CONTAINS ( C1 , ' * School * ' )

return for you all record that in C1 has MySchool , OurSchool and ...  too or Like this

but in SQLite 

SELECT  *   FROM   Table1   WHERE  C1  MATCH (  ' * School * ' )

return only Shool

 I'm not familliar with the "CONTAINS" word. Why not try this?

SELECT * FROM Table1 WHERE C1 LIKE '%School%'

 ya i khow that but if you type

ELECT  *   FROM   Table1   WHERE  C1  MATCH (  ' School * ' )

too  result is same

my question is why result in sql server and sqlite is defrence and sql server is better in answer???