title: Read files in directory in order of filename prefix with batch?
body: <p>I have a number of SQL scripts in a directory, prefixed with a number, e.g.</p>
  
  <p><img src="https://i.stack.imgur.com/k1hg4.png" alt="enter image description here"></p>
  
  <p>Currently, I'm able to loop through them with this script:
  </p>
  
  <pre><code>@ECHO OFF
  FOR /r . %%F IN (*.sql) DO (
      ECHO File:"%%F"
  )
  </code></pre>
  
  <p>However, because of the way that Windows reads files in a directory, 10 and 11 are read before 2, etc.:</p>
  
  <p><img src="https://i.stack.imgur.com/koenk.png" alt="enter image description here"></p>
  
  <p>How can I loop through each file in the directory, <strong>in order of the prefix</strong>?  </p>