title: Using a GUID In The Where Clause
body: <p>For some reason I'm unable to use comparisons on GUID columns, it does not return any results.</p>
  
  <p>See below, with the WHERE clause set to the exact value of the 'secguid' column, it does not return any results. What's going on? </p>
  
  <pre><code>SELECT * FROM dbMobileFile
  
  SELECT * FROM dbMobileFile WHERE secguid = '3137459D-EFDE-449E-94A3-89345A8580FA'
  
  SELECT * FROM dbMobileFile WHERE secguid LIKE '3137459D-EFDE-449E-94A3-89345A8580FA'
  </code></pre>
  
  <p>Using LIKE does not work either.</p>
  
  <p><a href="https://i.stack.imgur.com/byLV4.png" rel="noreferrer"><img src="https://i.stack.imgur.com/byLV4.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/ESsJH.png" rel="noreferrer"><img src="https://i.stack.imgur.com/ESsJH.png" alt="enter image description here"></a></p>