Replacing a single quote with 2 single quotes in XSL

[dhascuba]

The @name field can contain a single quote in it such as: Mike O'Grady.
Since this is creating and SQL statement on the server side, it will not process the name if it has a single quote in it. Id' like to replace that single quote with 2 single quotes without destroying th rest of th data in the field. Currently I replace a single quote with a "^" and then do a replace of that on the server side, see last <zz>. That statement is ecexuted on the other side. Please help, if there is help......Don.
Here;s the crude XSL doc:

<?xml version="1.0"?>
 <!-- ******************************************************************** -->
 <!-- * This XSL is used to transform the mampcp document to * -->
 <!-- * SQL script that will insert the decomposed data to our mampcpwrk file * -->
 <!-- * table. * -->
 <!-- ******************************************************************** -->
 <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"
    xmlns:php="http://php.net/xsl">
    <xsl:output method="text" indent = "no" encoding="UTF-8"/>
    <!-- Process complete tree starting from root-->
    <xsl:template match="pccList">
   <!-- Process each repeating MEMBER-INFO -->
    <xsl:variable name="old">'</xsl:variable>
    <xsl:variable name="new">^</xsl:variable>
      <xsl:for-each select="pcc">
    insert into  mampcpwrk (name,prcode,wrkph2,adrln1,zipcod,zipcod4,titlcd,
     provno,wrkph1,adrln2,citycd,stacod) 
    values (&apos;<xsl:value-of                                                 select="translate(@name,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@cde_service_loc,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@num_phone,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@adr_mail_strt1,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@adr_mail_zip,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@adr_mail_zip_4,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@nam_title,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@id_provider,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@num_area_code,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@adr_mail_strt2,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@adr_mail_city,$old,$new)"/>&apos;,
    &apos;<xsl:value-of select="translate(@adr_mail_state,$old,$new)"/>&apos;);
     </xsl:for-each> 
     <zz>update mampcpwrk set name=replace(name,&apos;^&apos;,&apos;&apos;&apos;&apos;);</zz>
    </xsl:template>
 </xsl:stylesheet>