title: Syntax error (missing operator) in query expression ‘[Type]=5 And Left([Name],1)<>"~" OORDER BY [Name]’
body: <p>I have to create a list box control that contains all of the queries except for the system queries. Recall that system query names begin with the <code>~</code> character. </p>
  
  <p>When I try to write SQL code in the row source (in the property sheet) for my <code>frmQueries</code> form I keep getting an error saying:</p>
  
  <blockquote>
    <p>Syntax error (missing operator) in query expression:<br/>'[Type]=5 And  Left([Name],1)&lt;>"~" OORDER BY [Name]'</p>
  </blockquote>
  
  <p>The code I entered is:</p>
  
  <pre><code>SELECT [Name] FROM MYSysObjects
  WHERE [Type]=5 And Left([Name],1)&lt;&gt;"~" 
  OORDER BY [Name];
  </code></pre>
  
  <p>I am not sure why I am getting this error or how I can fix it.</p>