>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'
>

This will not work. In the example below, if the field 'EMP.login_lvl' has '39296' stored in character string format.

SELECT EMP.pers_no FROM EMP WHERE BITTEST( VAL(EMP.login_lvl), 7 )

That string is converted to Numeric. Then the BITTEST() sees it as: "1001 1001 1000 0000" Which is the binary equivilent of "39296"

Thanks anyway.
Mike