title: Access UPDATE query using Regular Expressions
body: <p>I have created the following Regular expression in javascript to test if the string works.</p>
  
  <pre><code>var str = "Test [abc] =1234= (PG1/2)";
  var pattern = /[\[]/; 
  var pattern1 = /[\]]/; 
  var pattern2 = /[=?]/;
  var pattern3 = /[\(]+[A-z0-9\/]+[\)]/;
  var result = str.replace(pattern1, "").replace(pattern,"").replace(pattern2, "[").replace(pattern2,"]").replace(pattern3,"");
  </code></pre>
  
  <p>which works perfectly fine. However no i have tried to convert this SQL (using the ms access sample database)</p>
  
  <p>i have tried the following which hasn't worked as i get an error.</p>
  
  <pre><code>UPDATE Orders
  SET Orders.ShipName=replace(replace( Orders.ShipName, "/[\[]/", ''), "/[\]]/",'');
  </code></pre>
  
  <p>which didn't work. I think I've gone about the wrong approach to the SQL. can anyone advise on the correct way to do this? as all of the replaces are required to be executed on the Orders.ShipName field. Is this even possible?</p>