title: SQL Server FullText search for phrase containing punctuation, e.g. IP address?
body: <p>I'm using SQL Server fulltext to search text in large varchar/varbinary columns that may contain IP addresses.  I understand that the dots in the address aren't in the index, but I thought a phrase search such as this would work:</p>
  
  <p>select * from myFTETable where contains(myFTEcolumn, "192 168 100 101")</p>
  
  <p>It doesn't.  What am I doing wrong?  Is there a way to search for IP addresses, or more generally is there a way to do a phrase search when the phrase in the original data contains punctuation?</p>
  
  <p>Thanks.</p>