Hi Here is the example I worked..
> Creating the table SqlLite.exe test.db "create table t3 (t3key INTEGER PRIMARY KEY,path TEXT,num double,timeEnter DATE , validate BOOL);" > Inserting into the table SqlLite.exe test.db "insert into t3 (path,num) values ('D:/CCVweiew/sampleexample/data/path',3);" SqlLite.exe test.db "insert into t3 (path,num) values ('D:/CCdfView/sample/dadfta2/abcd',3);" SqlLite.exe test.db "insert into t3 (path,num) values ('D:/CCVdfiew/sample/data/efgh',3);" > SqlLite.exe test.db "select * from t3 "; t3key = 1 path = D:/CCVweiew/sampleexample/data/path num = 3.0 timeEnter = NULL validate = NULL t3key = 2 path = D:/CCdfView/sample/dadfta2/abcd num = 3.0 timeEnter = NULL validate = NULL t3key = 3 path = D:/CCVdfiew/sample/data/efgh num = 3.0 timeEnter = NULL validate = NULL > updating when path matches '/sample/' SqlLite.exe test.db "update t3 set validate=500 where path like '%/sample/%'" >SqlLite.exe test.db "select * from t3 "; t3key = 1 path = D:/CCVweiew/sampleexample/data/path num = 3.0 timeEnter = NULL validate = NULL t3key = 2 path = D:/CCdfView/sample/dadfta2/abcd num = 3.0 timeEnter = NULL validate = 500 t3key = 3 path = D:/CCVdfiew/sample/data/efgh num = 3.0 timeEnter = NULL validate = 500 Hope it solves ur probs.. -- ABC mikewhit wrote: > > Gerasimos Xydas <[EMAIL PROTECTED]> writes: > >> >> Hello, >> >> I have built an SQLite 3 database from C code. >> >> CASE 1 >> ======== > ... >> CASE 2 >> ======== > ... >> >> Best regards, >> Gerasimos >> > > Search the newsgroup ... start here > http://thread.gmane.org/gmane.comp.db.sqlite.general/42112 > > Regards, > MikeW > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/LIKE-operator-to-support-GREEK-tp20341577p20374899.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users