title: output filename, not string with select-string
body: <p>I'm using powershell to "grep" my source code for a particular string.  If the string is in the file, I would like the name of the file, not the line of code that contains the string.</p>
  
  <p>I would also like the name of the file, just once, not listed for as many times as the file exists.</p>
  
  <p>I'm currently using:</p>
  
  <pre><code>gci . -include "*.sql" -recurse | select-string -pattern 'someInterestingString'
  </code></pre>
  
  <p>Now I understand that the output of select-string is some sort of ojbect, and what I'm seeing in the console is, i'm guessing, the <code>ToString()</code> of that object.  I assume that I could use <code>format-table</code> to control the output of the select-string, and I suppose <code>sort</code> to get distinct values only.</p>
  
  <p>but that's a lot of guessing.</p>