Hi,
Thanks a lot for the support. We are actually using sqlite3_snprintf() with the proper buffer size to make sure that overflow will not happen. and also bind operations. INSTR() seems to be the best option. It seems to be fine. Thanks a lot. Thanks and Regards Deepak ________________________________ From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of R Smith <ryansmit...@gmail.com> Sent: Friday, January 5, 2018 3:41:35 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Search % using sqlite On 2018/01/05 10:14 AM, Rowan Worth wrote: > For this simple search it's easier to replace "NAME LIKE ?" with > "instr(NAME, ?) > 0", unless you need case insensitive matching. And in case you do wish for Case-Insensitive matching while using Rowan's method... "instr(UPPER(NAME), UPPER(?)) > 0" (Or LOWER(), if you so wish). _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
