How to do a Select concat on bit fields in SQL Server?
Posted on 2004-04-04
I have 4 bit (boolean) fields that together comprise the status of the record.
If taken as a group, these bits might be 0001, 0010, 0011, etc for the 16 possible
What I can't figure out is how to select them as a single value. Everyone I ask
suggests using "select concat (f1, f2, f3, f4) as state" but concat is a MySQL dialect
only, I think.
Can someone tell me how to have these 4 binary values returned as one.