This reproduces the issue for me: create table config (config_package integer, config_flags integer); insert into config (config_package, config_flags) values (1, 2); insert into config (config_package, config_flags) values (2, 4); insert into config (config_package, config_flags) values (3, 6); select config_package, config_flags, (config_flags & '4') from config where (config_flags & '4') != '4';
This produces: 1|2|0 2|4|4 3|6|4 While it should only have returned the first row. -- =============================== Maurice van der Stee (s...@planet.nl) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users