Re: [SQL] select a part of a name

use: where name like '%names%' 

On Wed, 8 Dec 1999, Vladimir Terziev wrote:

> 
> 
>         You must write:
> 
>         select * from TEST where name ~ '&name';
> 
>         This will match all names containing &name
> 
> 
>         Vladimir
> 
> 
> 
> On Wed, 8 Dec 1999, Fred Schoonewille wrote:
> 
> > Hi,
> > 
> > I am trying to select a part of a name from the columm NAME,
> > 
> > e.g. sql asks the user for input like:   jone
> > 
> > sql should give all names which begin with or containing 'jone'
> > 
> > -jones
> > -Tom-Jones
> > 
> > Working with:
> > 
> > select * from TEST
> > where NAME= '&name'
> > 
> > finds only exact matches
> > 
> > Can I use e.g.  %    ?
> > --
> > 
> > -----------------------------------
> > Fred Schoonewille
> > 
> > Applicatiebeheer
> > Computer Ondersteuning Hoboken
> > -----------------------------------
> > http://www.eur.nl/fgg/coh
> > -------------------------------------------------------
> > 
> > 
> > 
> > 
> > 
> > ************
> > 
> > 
> 
> 
> ************
>