Re: Use contains

With Sql use

Select no where nom like '%more%';

"Robert Thibault" <rthibeau_at_videotron.ca> wrote:

>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');
>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