title: SQL Server 2008 LIKE query
body: <p>I want to use <code>LIKE</code> query to select some specific word just like <code>UU1</code>.</p>
  
  <p>I use</p>
  
  <pre><code>SELECT UniID FROM MasterCustomer  where (UniID like '%uu1%' )
  </code></pre>
  
  <p>But it also returns a row which contains <code>UU11</code>.</p>
  
  <p>How can I modify my query to select only <code>UU1</code>?  </p>
  
  <p>My table contains values like</p>
  
  <pre><code>UU1-UU7-UU5
  UU2-UU1
  UU3-UU1
  UU31-UU14
  </code></pre>