在SQL中，如何将位掩码总数中的值拆分为逗号分隔的字符串

I have a bitmask value stored as an int in sql. I'd like to turn that value into a comma separated list of the values contained in the bitmask value. I have a bitmask value stored as an int in sql.