Does anyone have a sql they can share to determine if a specific bit is on?

ie...

I have a field which is a 1 character field that I need to determine if
bit...5 is on going from right to left.

ie... 00010000 The datatype of the field is char(1).




DB2 & UDB email list listserv db2-l LazyDBA home page