title: Find absolute path to a directory if given path to start search from (in a batch file)
body: <p>A user will give me an absolute path - say "C:\src" (passed into %1 in the batch file). Then, I need to find the directory entitled "SQLScripts" that is in some subfolder of "C:\src".</p>
  
  <p>How can I find the absolute path to the "SQLScripts" directory? Also, I'm not worrying about multiple instances of the SQLScripts directory existing.</p>
  
  <p>From my Googling, the solution may involve a for loop and some batch modifier such as %~$PATH:1. This link may be beneficial - <a href="http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/percent.mspx?mfr=true" rel="nofollow noreferrer">Special Batch Characters</a>.</p>
  
  <p>All solutions need to work on Windows XP and above.<br>
  Note that I'm constrained to using a batch file, and can't use other "easier" methods such as a simple Python code snippet to solve my problem.</p>
  
  <p>Thanks!</p>