I have a column of size 8 bytes. I want to extract all the records with the 4th byte having specific values. For eg.
from the above sample table, i want to extract all the records having the value "2" in the 4th position of that column-1.
I can think of "_" but not sure how to use against a specific position, like 4th byte only.
Can some one please help me with the WHERE clause for this getting the above desired result?
Thanks in advance