Search with multi result?

[baby]

Hi guys i am told to do a site with asp language.

After entering entry into database theres a search button that allows user to key in what they wanted to search.

When user search for items that only have one in database its no problem. But what my project supervisor wanted is when users search for non-unique key like company? they will show all the results that have the same company...

how do i go about doing this?

please help =)

[Danial]

Originally posted by baby
Hi guys i am told to do a site with asp language.

After entering entry into database theres a search button that allows user to key in what they wanted to search.

When user search for items that only have one in database its no problem. But what my project supervisor wanted is when users search for non-unique key like company? they will show all the results that have the same company...

how do i go about doing this?

please help =)

You can use SQL query to return the search result.
e.g

Select * From MyTable where Company_Name ='Company'

or
Select * From MyTable Where Company_Name Like 'Company*'