Column headers in a table functioning as input boxes for filtering

Is it a good idea to use column headers as input boxes for filtering the results in a table?

Answer

Traditionally, grids are designed in such a way that when the user clicks on the header of a column, the values in the table are sorted in ascending or descending format.

One way to include search/filter in the same header area is to add a search icon at the right corner of the cell as shown below.

When the user clicks/taps on the search icon, you can replace the header label with the filter textbox which can implement autocomplete feature as shown below.

Hope that helps.