A great way to search records on client-side without getting using stored procedures or SQL script just by using jQuery and css stylesheets.
Usually, many developers make use of stored procedures or SQL scripts to
perform search which is kind of a common approach. It includes
number of steps such as: writing a long stored procedure, placing a text
box on your page that will enable a user to type a search term, execute
the stored procedure on the search button click and passing the types
parameter to the stored procedure and the results are displayed.