I get the following error when I use % or _ error @ 101, 1,1,unrecognized token: "'м"
On Tue, Sep 6, 2011 at 9:21 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > On 9/6/2011 11:41 AM, Sreekumar TP wrote: > >> If I modify the statement to return all strings which match 'м' , No >> strings >> are fetched. >> >> zSQL = sqlite3_snprintf(1024,temp2,"**SELECT * FROM l1 WHERE data LIKE >> 'м' >> ;"); >> > > You probably want LIKE 'м%'. It's rather pointless to use a LIKE operator > with no wildcards. > -- > Igor Tandetnik > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users