title: Searching in SQL Server in C# through multiple columns
body: <p>I have a table that has about 40 columns, some text, some numbers, booleans etc. Currently I have a <code>HasComputedColumnSql</code> method that combines 4 out of the 40 columns into one called <code>combinedSearch</code>.</p>
  <p>I perform a wildcard search on the <code>combinedSearch</code> column, but now I'd like to add an additional 20 columns to be searchable, but I really don't like combining the values into a single column.</p>
  <p>What other options would you recommend?</p>