title: Sql Server Contains
body: <p>I need to match on a partial string but can't turn full-text indexing on so can't use contains. I've looked at Levenstein's function for determining the distance between two strings but I'm not looking for fuzzy matching but that every character in the column exists in the string.  </p>
  
  <p>I.e. If the string being passed is something like AB_SYS_20120430.TXT I want to match on any columns containing AB_SYS. The like predicate isn't getting me there.  I really need the equivalent of the .NET contains feature but as mentioned turning on full text indexing isn't an option to be turned on.  Thought I would see if there were any other possible work arounds.  </p>