Paul Sanderson wrote:
> I have a table with an integer value which is a bitmask.
>
> 0c01 readonly
> 0x02 hidden
> 0x04 system
> 0x10 directory
> 0x20 archive
>
> I'd like to create a query which would take an attribute, say 0x07 and spit
> out "system, hidden, readonly"
SELECT substr(CASE WHEN attr & 32 THEN ', archive' ELSE '' END ||
CASE WHEN attr & 16 THEN ', directory' ELSE '' END ||
CASE WHEN attr & 4 THEN ', system' ELSE '' END ||
CASE WHEN attr & 2 THEN ', hidden' ELSE '' END ||
CASE WHEN attr & 1 THEN ', readonly' ELSE '' END, 3)
FROM MyTable;
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
