> I use vb What wrapper is that?
RBS On Wed, May 26, 2010 at 6:14 PM, ro...@zhole.com <ro...@zhole.com> wrote: > I use vb or in SQLlite Expert the * does not seem to work > From my testing * doesn't seem to work in the likeif I use '%33' it returns > everything with test33if I use '33%' it returns everything with 33testif I > use '%33%' it returns everything with 33test, test33 which is the same as > * > Hope this helpsRoger > > ---------------------------------------- > From: "Jean-Christophe Deschamps" <j...@q-e-d.org> > Sent: Wednesday, May 26, 2010 12:54 PM > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Subject: Re: [sqlite] how to search for asterix character? > >>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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users