title: Bigquery SELECT * FROM table where column = 'string' not returning any values
body: <p>When I run the following query in bigqeury I am getting no results.</p>
  
  <pre><code>SELECT COUNT(*) FROM raw.bicc_customers WHERE sub_type = "SUD"
  </code></pre>
  
  <p>I don't get any results</p>
  
  <p>However, when I run</p>
  
  <pre><code>SELECT COUNT(*) FROM raw.bicc_customers WHERE sub_type LIKE "%SUD%"
  </code></pre>
  
  <p>I get results. The field that I'm looking for is SUD with no spaces, I don't understand why I need wildcards to find it. What am I missing?</p>
  
  <p>EDIT:</p>
  
  <p>So in the table the column is actually "SUD" - How would you find this without wildcards?    </p>