title: How to replace all occurrences of matching string in a database table using ColdFusion
body: <p>Working with a MS Access database, using one particular table, and scattered throughout the table at varying positions in date columns (which themselves can be in varying orders as a result of the data import) is the text "Not known". I want to replace occurrences of that text string across the whole data table.</p>
  
  <p>The only way I can think of doing it is export to a csv format, and do a REReplace then import the data again, but I would like to know if there is a 'slicker' way?</p>
  
  <p>The columns contain data which is a data import from a csv file so all the columns are text,  they can contain a mix of "date string", text, numbers (as string) and null. </p>