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