title: Is there any way to search for numbers with leading zeros in SQL Server Full-text indexes
body: <p>We have table with a Body (NVARCHAR(MAX)) column that contains text from emails and files.  The column is full-text indexed. </p>
  
  <p>Some of the documents contain reference numbers such as 00123. However the full-text engine seems to strip leading zeros so when we search using <code>CONTAINS(Body, '00123')</code> it also returns false positives containing just 123.</p>
  
  <p>Is there anyway to fix this? Ideally there would be a way to address this in the query, but we would also consider other options such as alternative word breakers etc. </p>
  
  <p>We are using SQL Server 2008 R2 and later.</p>