title: Replace text with another text in a clob field
body: <p>Getting error when executing the script. I am try to replace oracle to_date text with sql server convert(datetime_
  Msg 102, Level 15, State 1, Line 9
  Incorrect syntax near '02'.
  Msg 132, Level 15, State 1, Line 9
  The label 'HH24' has already been declared. Label names must be unique within a query batch or stored procedure.
  Msg 132, Level 15, State 1, Line 9
  The label 'MI' has already been declared. Label names must be unique within a query batch or stored procedure.</p>
  
  <p>Looked in google for solutions on how replace works, could not find a solution on how to handle the labels, but i don't think it is lable. I am just replacing one text for another. Looks like sql server does not like oracle time definition. </p>
  
  <pre><code>update table
  set table.clobfield = REPLACE(table.clobfield,'BETWEEN TO_DATE('02/01/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS') AND TO_DATE('02/10/2011 23:59:59', 'MM/DD/YYYY HH24:MI:SS')',
  'BETWEEN CONVERT(DATETIME, '02/01/2011 00:00:00') AND CONVERT(DATETIME,'02/10/2011 23:59:59')')
  </code></pre>
  
  <p>I expect sql sever text to replace the oracle to_date text</p>