Re: [SQL] select a part of a name

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