Hi all,
Is there a 'Flag' datatype I can use in SQL Server (2000 or 2005 versions)? What I mean by a flag datatype is similar to the [Flag] attribute of a .Net enum class. For example:

location types can any one or more of the following:
Plant 0x01
Hub   0x02
Whse  0x04
...

where i actually store the combination of the location types. Or, is there a decimal to hex function in SQL Server I can use for this?