> > The query is on a visits table from a google chrome history database. The > query seems to work OK if a single bit is set, but fails (a blank string is > returned) when multiple bits are set. Any ideas why? >
It's because none of the WHEN 0x... cases, except 0xC0..., have multiple bits set. The approach you've chosen requires enumerating all the possible combinations (all 2^5 of them in this case). You are better off with one of the other suggested approaches by Richard Hipp or RSmith. e _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
