Use contains

I 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');
[Quoted] [Quoted] 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