I have a table with an integer value which is a bitmask. one or more of the bits can be set and each bit has a corresponding meaning.
so using the windows file attribute as an example we have 0c01 readonly 0x02 hidden 0x04 system 0x10 directory 0x20 archive none, any or all could be set I'd like to create a query which would take an attribute, say 0x07 and spit out "system, hidden, readonly" Cheers _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
