title: Full text search on calculated columns
body: <p>I need to allow full-text searching on two fields that are concatenated together. In this case, FullName = FirstName + ' ' + LastName. The simple approach seems to be to create a FullName calculated column then include that as a column in the full-text indexing. Is this an acceptable approach? How would you do it?</p>
  
  <p>UPDATE and INSERT happens very rarely, SELECT using CONTAINS is very common by comparison. I'm using SQL 2008.</p>
  
  <p>Sample table definition where FirstName, LastName, NickName and FullName are columns used in the full-text search:</p>
  
  <pre><code>TABLE Player
      Id uniqueidentifier ROWGUIDCOL NOT NULL DEFAULT (newid()),
      ...
      FirstName nvarchar(128),
      LastName nvarchar(128),
      NickName nvarchar(128),
      FullName  AS ([FirstName]+' '+[LastName]) PERSISTED
  </code></pre>