title: Quickie - replace all occurrences of ' (apostrophe) with '' (two apostrophes) in an AnsiString (C++)
body: <p>I think you can guess the problem I'm having.  I'm inserting filenames in to an sql database in C++ Builder.  Some files have an apostrophe in their name.  This breaks the sql insert query.  the usual way to fix this is to double up and apostrophes you want to be part of the field value.</p>
  
  <p>For example if I want to add 'george's' to field 'owner' the sql query would be "insert into table (owner) values ('george''s')"</p>
  
  <p>I'm ok with that bit.  I just need to get the single apostrophes replaced with double ones.  AnsiString doesn't seem to have a built in function for this.   Is there a simple way to do it without having to include a whole new header file?</p>