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