"Bart Smissaert" <bart.smissa...@gmail.com> schrieb im Newsbeitrag news:aanlktikivzcbz81hqs28dtptoy8h6hc6nbukesmth...@mail.gmail.com...
> > "...Where SomeColumnContent Like '%someother[*]part%' > > Thanks Olaf, that works fine. > As my customers won't get this I think I might let my > code take care of this. Perhaps a good idea. ;-) > How would it work with glob? Umm, not a glob expert <g> don't use it here (yet). my first thought would be, to precede the char in question with an escape-char (as the backslash)... testing... No, it apparently works in the same way as my overridden like per: "...Where SomeColumnContent glob '*someother[*]part*' But possibly not case-insensitive (not tested, that) - and not "unicode-aware" of course. Olaf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users