title: Search a table field for a subscript of a string in SQL server
body: <p>I have a table which looks like this:</p>
  
  <pre><code>**Description**
  North
  East
  West
  South
  </code></pre>
  
  <p>Now if I want to search the table in the column description using a subscript of a string like for example I want to search the value North but the available string I have is "ValueNorth"</p>
  
  <p>its like this sample SQL:</p>
  
  <pre><code>SELECT Description FROM Table1 WHERE Description = 'ValueNorth'
  </code></pre>
  
  <p>Now what I want to display in the result is the value of North in the description.</p>
  
  <p>Is it possible in SQL server.</p>
  
  <p>Thanks for the help</p>