title: Regular Expression - Want to find a match for a word but only if it does not appear after certain characters
body: <p>Please help me find a regular expression that will do the following.....</p>
  
  <p>I have a file that could contain lines such as...</p>
  
  <pre><code>with replace into currency;
  --if at least one client currency is not found
  @id_base int,              -- base currency Id
  from currency            -- need this table as it stores the fx currency
  </code></pre>
  
  <p>I need to search this file and return any lines that contain the word <strong>currency</strong> BUT only if there is no <strong>--</strong> before it. The -- represents a comment and can be excluded however as you can see from the last line above I may get a case where the word is included in the comment section and non comment section so in this case it should be classed as a match so from the above file i would expect only the following lines to return.</p>
  
  <pre><code>with replace into currency;
  from currency            -- need this table as it stores the fx currency
  </code></pre>
  
  <p>Can anyone help?</p>