Just use prepared statements, what someone else called parameterized queries. They are more flexible and not prone to sql injections.<br><br><div class="gmail_quote">On Mon, Sep 20, 2010 at 2:20 PM, Jangita <span dir="ltr">&lt;<a href="mailto:jangita@jangita.com">jangita@jangita.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;">&#39;murang&#39;&#39;a&#39; ?<br>
<br>
<br>
Jangita | +254 76 918383 | MSN &amp; Y!: <a href="mailto:jangita@yahoo.com">jangita@yahoo.com</a><br>
Skype: jangita | GTalk: <a href="mailto:jangita.nyagudi@gmail.com">jangita.nyagudi@gmail.com</a><br>
<br>
<br>
<br>
From: <a href="mailto:skunkworks-bounces@lists.my.co.ke">skunkworks-bounces@lists.my.co.ke</a><br>
[mailto:<a href="mailto:skunkworks-bounces@lists.my.co.ke">skunkworks-bounces@lists.my.co.ke</a>] On Behalf Of Calvin Omari<br>
Sent: 20 September 2010 10:03 AM<br>
To: Skunkworks Forum<br>
Subject: [Skunkworks] Apostrophe string in mssql<br>
<div><div></div><div class="h5"><br>
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>
<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>
<br>
</div></div><div><div></div><div class="h5">_______________________________________________<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>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Solomon Kariri,<br><br>Software Developer,<br>Cell: +254736 729 450<br>Skype: solomonkariri<br>