Hi All,
We are implementing a wild card search feature. our query is as below: sprintf (acQstring, "SELECT NAME FROM AUDIO WHERE NAME LIKE '%%%s%%'", acInputString); In the input string is '%' then we are getting t all the entry in the column. ex: name column have following: %a a a%a aa% we are expecting entry 2 which don't have % in it should not get as output. But it seems not the case, it is giving all the 4 entry as output. Please can we know is there any way of searching this? Thanks. Thanks and Regards Deepak _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users