Search functionality

[Illegal Operation]

Hi, I need to find out how to impliment Search functionality on a website, using SQL 2000 and C#. Basically "How do I start setting up the querries in SQL to start searching for words?" Thank a Million! Illegal Operation Making Computer Software Talk

[xaphod]

Try this SQL: SELECT productName FROM tProducts WHERE prodName LIKE 'fish%' Returns: productName -------- fishy coke fishfinder fish fishermans friend Change searchcritera 'fish' to your variable. GL /x