Yes, thanks, it looks it might indeed be the (VB) wrapper that is to blame here. Will contact the developer.
RBS On Wed, May 26, 2010 at 5:53 PM, Jean-Christophe Deschamps <j...@q-e-d.org> wrote: > >>How do I search for the asterix character * ?? >> >>This doesn't work: >>select field1 from table1 where field1 like '%FH%*%' >>as the * character here seems to be ignored. >> >>Using the latest version of SQLite. > > You're doing it right. Either you use a wrapper that messes with * in > litterals or there is actually no matching row. Try using the > command-line tool to better diagnose what's going on here. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > 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