Great this worked and i also used tried the following<br> function escapeSingleQuotes($string){<br>        //escapse single quotes<br>        $singQuotePattern = &quot;&#39;&quot;;<br>        $singQuoteReplace = &quot;&#39;&#39;&quot;;<br>
        return(stripslashes(eregi_replace($singQuotePattern, $singQuoteReplace, $string)));<br>        }<br><br><br><div class="gmail_quote">On Mon, Sep 20, 2010 at 12:30 PM, Nd&#39;wex Common <span dir="ltr">&lt;<a href="mailto:flexycat@gmail.com">flexycat@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><span><b></b></span>$varString = $_POST[&#39;Address&#39;];<br>str_replace(&quot;&#39;&quot;, &quot;&#39;&#39;&quot;, $varString);<div>
<div></div><div class="h5"><br><br><div class="gmail_quote">On Mon, Sep 20, 2010 at 12:09 PM, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com" target="_blank">calvinebarongo@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Am working on a php mssql app,<br>please can you give me an exapmle of parametrized in the Murang&#39;a case am using php $address=$_POST(&quot;Address&quot;)<br>

This address contains MURANG&#39;A with an apostrophe<br>Regards<div><div></div><div><br>
<br><div class="gmail_quote">On Mon, Sep 20, 2010 at 11:53 AM, Nd&#39;wex Common <span dir="ltr">&lt;<a href="mailto:flexycat@gmail.com" target="_blank">flexycat@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">


That will heavily depend on whic application you are working with<br>classic ASP, VBScript =&gt; Replace(varString, &quot;&#39;&quot;, &quot;&#39;&#39;&quot;)<br><br>Im not sure on the .Net frontier<div><div></div><div>
<br><br><div class="gmail_quote">
On Mon, Sep 20, 2010 at 11:23 AM, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com" target="_blank">calvinebarongo@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">



Because am doing an insert from an application is there a way I can do string repalce such that i whenever a name like Murang&#39;a appears the  &#39; will have to be repalced by &#39; &#39; ( two apostrophes)<br>Thanks<div>



<div></div><div><br>
<br><div class="gmail_quote">On Mon, Sep 20, 2010 at 11:18 AM, Isaak Mogetutu <span dir="ltr">&lt;<a href="mailto:imogetutu@googlemail.com" target="_blank">imogetutu@googlemail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">




<b><code style="font-family: courier new,monospace;">INSERT myTable (columnName) VALUES (&#39;This is Murang&#39;&#39;a&#39;)</code></b><br><br>This will insert a single quote or apostrophe into the field between the &quot;g&quot; and the &quot;a&quot;.
<br><br>--not tested<div><div></div><div><br><br><div class="gmail_quote">On 20 September 2010 11:13, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com" target="_blank">calvinebarongo@gmail.com</a>&gt;</span> wrote:<br>







<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">@Isaak Thanks so much do we have the same syntax in Microsoft sql server 2005<div><div></div>







<div><br><br><div class="gmail_quote">On Mon, Sep 20, 2010 at 11:10 AM, Isaak Mogetutu <span dir="ltr">&lt;<a href="mailto:imogetutu@googlemail.com" target="_blank">imogetutu@googlemail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><b style="font-family: courier new,monospace;">$foo = &quot;This is Murang&#39;a town&quot;;
<br>
<br>$sql = &quot;INSERT INTO mytable SET comments = &#39;&quot;.mysql_real_escape_string($foo).&quot;&#39;&quot;;</b>
<br><br><div class="gmail_quote"><div><div></div><div>On 20 September 2010 11:03, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com" target="_blank">calvinebarongo@gmail.com</a>&gt;</span> wrote:<br>








</div></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div><div></div><div>

Hi Techies,<br>How do we insert words like<br>&#39;Murang&#39;a&#39; in mssql as it will be seen as an unclosed quote<br>Regards<br clear="all"><font color="#888888"><br>-- <br>Our greatest fear is not that we are inadequate,<br>










but that we are powerful beyond measure.<br>
It is our light, not our darkness, that frightens us.<br><br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> <br>
</font><br></div></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>











------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><font color="#888888"><br><br clear="all"><br>-- <br>mOgetutu<div><br></div><div><div><font face="&#39;courier new&#39;, monospace">| </font><font color="#ff0000"><font face="&#39;courier new&#39;, monospace">STOP</font></font><font face="&#39;courier new&#39;, monospace">! Before posting your questions, remember the WWW Golden rule:</font></div>










<div><font face="&#39;courier new&#39;, monospace">What did you try? What did you get? What did you expect to get?</font></div><div><font face="&#39;courier new&#39;, monospace">| Input -&gt; Controller | Processing -&gt; Model | Output -&gt; View</font></div>










</div><br>
</font><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>









------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Our greatest fear is not that we are inadequate,<br>but that we are powerful beyond measure.<br>








It is our light, not our darkness, that frightens us.<br><br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> <br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>








------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke<br clear="all"><br>-- <br>mOgetutu<div><br></div><div><div><font face="&#39;courier new&#39;, monospace">| </font><font color="#ff0000"><font face="&#39;courier new&#39;, monospace">STOP</font></font><font face="&#39;courier new&#39;, monospace">! Before posting your questions, remember the WWW Golden rule:</font></div>






<div><font face="&#39;courier new&#39;, monospace">What did you try? What did you get? What did you expect to get?</font></div><div><font face="&#39;courier new&#39;, monospace">| Input -&gt; Controller | Processing -&gt; Model | Output -&gt; View</font></div>






</div><br>
</a><br><br>
</blockquote></div>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>





------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Our greatest fear is not that we are inadequate,<br>but that we are powerful beyond measure.<br>




It is our light, not our darkness, that frightens us.<br><br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> <br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>




------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>



------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Our greatest fear is not that we are inadequate,<br>but that we are powerful beyond measure.<br>


It is our light, not our darkness, that frightens us.<br><br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo" target="_blank">http://www.facebook.com/barongo</a> <br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>


------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>

------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Our greatest fear is not that we are inadequate,<br>but that we are powerful beyond measure.<br>
It is our light, not our darkness, that frightens us.<br><br>Calvin Omari Systems Developer/Designer<br><a href="http://www.facebook.com/barongo">http://www.facebook.com/barongo</a> <br>