title: SQL SERVER CHARINDEX() not returning index for long search strings
body: <p>I've a field with XML data in a table and I'm trying to check if a certain keyword exists. When running <code>SELECT CHARINDEX('keyword', Table.Field) FROM Table</code>, its returning the index for some of them, but missing others where I clearly know the keyword exists.</p>