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