title: Salesforce API: How to retrieve a Case using a partial Case Id
body: <p>I'd like to retrieve a Case record from the Salesforce API. I only have the beginning of the Case Id <a href="https://stackoverflow.com/questions/6826843/salesforce-api-how-to-identify-a-case-from-an-email-reference-code-ref">(don't ask why)</a> so I've tried the following query:</p>
  
  <pre><code>SELECT Id FROM Case WHERE Id LIKE 'whatever...%'
  </code></pre>
  
  <p>Unfortunately, this returns the following error:</p>
  
  <pre><code>SELECT Id FROM Case WHERE Id LIKE '500DABCD...%'
                            ^
  ERROR at Row:1:Column:27
  invalid operator on id field'
  How can we get this functionality from the API?
  </code></pre>
  
  <p>Why can't I use the LIKE operator on the Id field? Is there some other way I can do this?</p>