title: Bulk Insert file name Like SQL server
body: <p>I have three files in my PRODUCTION folder. File names will be concatenated with current Dates. For example <code>PRODFILE1_01052014</code>, <code>PRODFILE2_01052014</code> etc. Daily files will be placed with current dates. I need to write an SP to BULK INSERT text files daily. I could write below script to bulk insert a particular dated file. How I can pick all the files that contains PRODFILE?</p>
  
  <pre><code>BULK INSERT PRODFILES FROM 'D:\PRODUCTION\PRODFILE1_01052014.TXT'
  WITH (FIELDTERMINATOR ='|',ROWTERMINATOR = '\n')
  </code></pre>
  
  <p>I need something like this <code>Like PRODFILE1*.txt</code>, <code>Like PRODFILE2*.txt</code></p>