MikeW <mw_p...@...> writes: > > If your list values are relatively small you could use a set > of bits for your IN clause and use > bitwise: WHERE ((1<<foreign.id) AND ?1) != 0 instead, where ?1 > encodes the required elements as bits set to 1. > ..snip.. > > Regards, > MikeW
Oops, that should be '&' not 'AND' ! MikeW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users