title: SQL Server - CHARINDEX always returns 0
body: <p>I have the following query:</p>
  
  <pre><code>SELECT 
     CAST([Action] AS NVARCHAR(4000)) AS CastAction, 
     CHARINDEX(CAST([Action] AS NVARCHAR(4000)), N'StatusChange') AS FoundIndex
  FROM AuditTrail 
  WHERE action LIKE '%StatusChange%'
  </code></pre>
  
  <p>Action is an NTEXT field - this query returns many rows, matching StatusChange in the action text, but the charindex returned is always zero... Any ideas - I need to be able to split this  string to tidy up some data?</p>