title: Matching pattern containing parentheses with sed
body: <p>I need to insert '--' at the beginning of the line if line contains word VARCHAR(1000)</p>
  
  <p>Sample of my file is:</p>
  
  <blockquote>
    <p>TRIM(CAST("AP_RQ_MSG_TYPE_ID" AS NVARCHAR(1000))) AP_RQ_MSG_TYPE_ID,
    TRIM(CAST("AP_RQ_PROCESSING_CD" AS NVARCHAR(1000)))
    AP_RQ_PROCESSING_CD, TRIM(CAST("AP_RQ_ACQ_INST_ID" AS NVARCHAR(11)))
    AP_RQ_ACQ_INST_ID, TRIM(CAST("AP_RQ_LOCAL_TXN_TIME" AS NVARCHAR(10)))
    AP_RQ_LOCAL_TXN_TIME, TRIM(CAST("AP_RQ_LOCAL_TXN_DATE" AS
    NVARCHAR(10))) AP_RQ_LOCAL_TXN_DATE, TRIM(CAST("AP_RQ_RETAILER" AS
    NVARCHAR(11))) AP_RQ_RETAILER,</p>
  </blockquote>
  
  <p>I used this command</p>
  
  <pre><code>sed 's/\(^.*VARCHAR\(1000\).*$\)/--\1/I' *.sql
  </code></pre>
  
  <p>But the result is not as expected.
  Does anyone have idea what am I doing wrong?</p>