title: Is there an equivalent to the SUBSTRING function in MS Access SQL?
body: <p>I want to do something like this within an MS Access query, but SUBSTRING is an undefined function.</p>
  
  <pre><code>SELECT DISTINCT SUBSTRING(LastName, 1, 1)
  FROM Authors;
  </code></pre>