I believe you can use SUBSTR function in Oracle and SQL would look like:
SELECT EMP.pers_no FROM EMP WHERE SUBSTR(EMP.login_lvl, 7, 1) = '1'
>Hi All,
>
>We have a field in our database that stores a BIT value in character format. Each of the BITs represents a user group. Since there are only 20 user groups we have yet to run into the 32 BIT limit problem.
>
>I am currently converting the programs to access an ORACLE database. So the following query is no longer valid because of the
BITTEST() Function.
>
>
>SELECT EMP.pers_no FROM EMP WHERE BITTEST( VAL(EMP.login_lvl), 7 )
>
>
>Is there a way to convert this? I'd like to create a Function on the database where I can just pass the BIT value to be tested and have all the
PERS_NOs returned.
>
>TIA
>Mike
>
>P.S. VFP6 SP5 Oracle 8i
- Jayesh