One problem with this George. My binary number is 80 (!) characters long. The limit on BITSET is 32. Any other suggestions?
I am basically trying to check for which positions are set to "1" in a string:
For example, if I am testing for locations 8, 12 and 39, I do:
SELECT *
FROM x
WHERE SUBSTRING(lcString,8,1) = "1"
OR SUBSTRING(lcString,12,1) = "1"
OR SUBSTRING(lcString,39,1) = "1"
This works but it takes some time. I thought about using BITSET and that's why I was trying to convert to numberic. Any other suggestions?
Thank you.
Aristotle