simon0304

Hi all, I have a database for insect species. I have set up a search box which a user can enter a keyword and it pull out any info from the database containing that word. I have two problems. Firstly Everything works ok, but I have just noticed that if no entry is place in the text box and the search button is pressed then everything from the database is displayed. Is there anyway to correct this. the script is as follows SELECT ID, BF, Vernacular, Taxon FROM species WHERE Vernacular LIKE '%colname%' ORDER BY Vernacular ASC Hope you can help Thanks Simon