SQL & PL/SQL

Hi,

I need to optimize this simple query:
select * from tabl1 where bitand(x, col1) != 0;

col1 is just an integer type that contains a bit map value.
An index on col1 does not do the job I always end up with full table scan. Does an Function Based Index help me out?

I need a helping hand,

Thanks,
Dieter