Simulate where clause on type Long?

Hello,

We've just implemented and Oracle database at work. One of the primary columns in one of the primary tables is of type Long (got'a be).

It was just brought to our attention today that users need to:

select "something" from Primary_table

        where Primary_column like '%something%';

I realize that type Long cannot be part of a where clause, as well as some other restrictions. Is there some work-around that would allow users to "search" for strings in this Long field?

Thanks,
Craig Duncan
Solaris 2.51
Oracle 7.3.3 Received on Thu Jul 30 1998 - 19:47:28 CDT