title: How do I use SQL to select only top level folders from a table of folders
body: <p>I have a table with a list of folders and I want to return only the top level folders.</p>
  <p>For example, if the original table (tblFolders) has a single column (Fldrs) as below:</p>
  <p><strong>Fldrs</strong></p>
  <pre><code>C:\Folder1
  C:\Folder1\Subfolder1
  C:\Folder1\Subfolder2
  C:\Folder2\Subfolder1
  </code></pre>
  <p>I'd like to return:</p>
  <pre><code>C:\Folder1
  C:\Folder2\Subfolder1
  </code></pre>
  <p>Thanks in advance</p>