>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 >*
I can't vouch for VB, but SQLite Expert --which I use extensively-- definitely handles asterisks '*' in litterals correctly. What do you mean with "which is the same as *". Asterisk has no special meaning for LIKE. You must be confusing with GLOB. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users