Search Script

Just replace rsCommon with your database connection, strInputSearch with the search word or request.form variable, tblTableName with your actual table name, and Field_name with your actually field_name you are searching.

Code:

<%
strInputSearch = "Your search word or form variable"

strSQL = "SELECT tblTableName.* FROM tblTableName "
strSQL = strSQL & "WHERE tblTableName.Field_name LIKE '%" & strInputSearch & "%';"

rsCommon.Open strSQL, adoCon

If rsCommon.EOF Then
      Response.Write("No Records Found")
Else
      DO UNTIL rsCommon.EOF
             Response.Write(rsCommon("Field_name") & "<br>")
      rsCommon.MoveNext
      Loop
End if

rsCommon.Close
%>