I have a table with 3 columns. The first column has Hexadecimals. The second column has the corresponding binary numbers. The third colmn has boolean values.
I need to select 4 records where the colC is False for the 4 records, the last two digits of the first record's colB (Binary value) are 00 and the other 3 records' ColB are the next consecutive binary numbers.
After selecting the records, Col C of those records must be updated to True.
I need these in a SQL function.