title: Why doesn't this LIKE query return any results?
body: <p>I made table copied from W3schools 2015 ... Here's some of the data: </p>
  
  <p><a href="https://i.stack.imgur.com/suaDa.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/suaDa.jpg" alt="enter image description here"></a></p>
  
  <p>here the columns and data types i used as follows.</p>
  
  <pre><code>CustomerID = int
  CustomerName = varchar
  ContactName = varchar
  Address = varchar
  City = varchar
  PostalCode = varchar
  Country = text
  </code></pre>
  
  <p>When i used the following query i got the actual result.</p>
  
  <pre><code>SELECT * FROM Customers WHERE Country LIKE 'U%';    SELECT * FROM Customers WHERE Country LIKE 'M%';    SELECT * FROM Customers WHERE Country LIKE 'G%';
  </code></pre>
  
  <p>Now the problem was that When i used the following query, i weren't getting actual result.</p>
  
  <pre><code>SELECT * FROM Customers WHERE Country LIKE 's%';    
  </code></pre>
  
  <p>i didn't see any row !!
  But We should have seen the following output,</p>
  
  <p><a href="https://i.stack.imgur.com/0Nw42.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0Nw42.jpg" alt="enter image description here"></a></p>
  
  <p>why ?? can anybody explain pls...</p>
  
  <p>Moreover I am totally in Novice phase..</p>
  
  <p>Thanks in Advance</p>