querying a long field

Is it possible to query a long field?

For example:

my table looks like

table: longtest

kol1 number;
kol2 long;

select kol2 from longtest where instr(kol2,'text')>0

thanks in advance for any help Received on Fri Jul 02 1999 - 08:55:06 CDT