Glob works fine as well with the [*] and is still case-sensitive and that is how it is intended. So this works fine:
select field1 from table1 where field1 glob '*FH*[*]' RBS On Wed, May 26, 2010 at 8:22 PM, Olaf Schmidt <s...@online.de> wrote: > > "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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users