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
please Help me !!