title: Stored Procedure - Search Parameter across multiple columns
body: <p>I have the following query that does the job just fine, but I'm wondering whether there is a better way to be doing it inside the <code>WHERE</code> clause.</p>
  
  <p>Any comments/feedback on improving it would be appreciated.</p>
  
  <pre><code>SELECT
      C.ClientID, 
      C.FirstName + ' ' + C.LastName as FullName, 
      C.DOB,
      G.Gender, 
      G.GenderIcon, 
      C.VerificationCode, 
      MAX(V.StartDate) as LastVisitDate
  FROM 
      Client C
  LEFT JOIN 
      Visit V ON C.ClientID = V.ClientID
  INNER JOIN 
      Gender G ON C.GenderID = G.GenderID
  WHERE
      (FirstName like '%' + @Criteria + '%' or
       LastName like '%' + @Criteria + '%' or
       VerificationCode like '%' + @Criteria + '%')
  </code></pre>