i do not know about mssql but in mysql we insert &#39;\&#39; before the apostrophe so murang&#39;a will be murang\&#39;a.<br><br>alternatively try insering it as a variable.<br><br><div class="gmail_quote">On Mon, Sep 20, 2010 at 11:03 AM, Calvin Omari <span dir="ltr">&lt;<a href="mailto:calvinebarongo@gmail.com">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;">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>_______________________________________________<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>