title: SQL - Space/blank character code
body: <p>I want to include a space/blank character in a query. I'm using a CASE condition which classify values write like : 'Syrah N', 'Chardonnay B', ... There is a space between my value and a capital letter. When the value started with the looked letter, query is useless (ex : 'Barbaroux RS' is classified B, but it must be RS). </p>
  
  <p>Actual query</p>
  
  <pre><code>SELECT name
  CASE 
     WHEN name LIKE '%N%' THEN 'Red'
     WHEN name LIKE '%B%' THEN 'White'
     WHEN name LIKE '%RS%' THEN 'Green'
     ELSE 'Other'
  END 
  FROM mytable
  </code></pre>
  
  <p>Wanted query</p>
  
  <pre><code>SELECT name
  CASE 
     WHEN name LIKE '% N %' THEN 'Red'
     WHEN name LIKE '% B %' THEN 'White'
     WHEN name LIKE '% RS %' THEN 'Green'
     ELSE 'Other'
  END 
  FROM mytable
  </code></pre>
  
  <p>How can i write '%<em>space</em>B<em>space</em>%' ?</p>