flags enum in Sql

I've been looking for the answer to this most of the day...Books Online doesn't say anything about how to solve this...

Anyone know how to make the equivilant of a "flags enum" in Sql 2000?