Re: Use contains

If I understand the question, you want

Select count(*) from test1
where contains(nom,'More') > 0

However, you're 'create index' must be of type 'Context' - you'll have to look up the
proper syntax.

> search how use "contains"
>for extract results.
>Ex
>create table test1
>(no number(2),
>nom varchar(255),
>prenom char(15));
>insert into test1
>values(1,'more babe','bob');
>insert into test1
>values(2,'sum tot more','you');
>create index ind_test1 on test1(nom);
>
>I wnat extract the no where the nom "contains" the word "more"
>
>thank you every body
>Cyber
>
Received on Fri Jun 30 2000 - 00:00:00 CEST