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
> > -------------------------------------------------------
> >
> >
> >
> >
> >
> > ************
> >
> >
>
>
> ************
>