title: How to use the SQL replace function effectively?
body: <p>I am trying to replace multiple rows in an Access database to follow a new set of data rules.  For instance, the word Fort in Fort Myers is listed as Ft., Ft and Fort.  I would like to make a global change to the group.  I am familiar with the SQL replace command, but wondering if anyone has done something similar with a stored procedure or had experience with something like this.  </p>