title: SQL Server CONTAINSTABLE not working for single digit numbers
body: <p>This question is about <a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/containstable-transact-sql" rel="nofollow noreferrer">SQL Server's FTS ContainsTable</a>.</p>
  
  <p>To replicate the issue, we can use the script below which will create one table and fill it with addresses.</p>
  
  <pre><code>CREATE TABLE Address (FullAddress nvarchar(100) NOT NULL);  
  CREATE UNIQUE CLUSTERED INDEX AddressKey ON Address(FullAddress);  
  INSERT INTO Address VALUES ('1 OLD YONGE ST, AURORA, ON');  
  INSERT INTO Address VALUES ('1 OLD YONGE ST, NORTH YORK, ON');
  INSERT INTO Address VALUES ('1 YONGE ST N UNIT 1, HUNTSVILLE, ON');
  INSERT INTO Address VALUES ('1 YONGE ST N UNIT 10, HUNTSVILLE, ON');
  INSERT INTO Address VALUES ('18 YONGE ST UNIT 324, TORONTO, ON');
  INSERT INTO Address VALUES ('10415 YONGE ST UNIT 1, RICHMOND HILL, ON');
  INSERT INTO Address VALUES ('11211 YONGE ST UNIT 37 BUILDING A, RICHMOND HILL, ON');
  </code></pre>
  
  <p>Now we will create the fulltext catalog and create an index on it.</p>
  
  <pre><code>CREATE FULLTEXT CATALOG AddressCat;  
  CREATE FULLTEXT INDEX ON Address(FullAddress) KEY INDEX AddressKey ON AddressCat; 
  </code></pre>
  
  <p><strong>Issue</strong></p>
  
  <p>If we run a query and search for addresses that start with <em>1</em> (Notice this is a single digit) and the <em>1</em> is <code>NEAR</code> the next term which is <em>Yong</em>, we expect it to return all the first 4 records above. Here is the query:</p>
  
  <pre><code>SELECT * FROM CONTAINSTABLE (Address, FullAddress, '"1" NEAR "Yon*"') ORDER BY RANK DESC;
  </code></pre>
  
  <p>However, it returns no rows. <strong>This is the issue.</strong></p>
  
  <p>But what if we execute a query with double digits such as <em>11</em> or <em>10</em>, then it will return records as expected.</p>
  
  <p><strong>Question:</strong></p>
  
  <p>Why will <code>ContainsTable</code> NOT return any results for single digit searches?  </p>