Some elementary issue in my code, works fine now. Tks -Sreekumar 2011/9/6 Sreekumar TP <sreekumar...@gmail.com>
> 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